Reserved Seat Information

[S Murur]

Hello Ranchers

I have a question about Reserved seat information. Where this information can be stored for a given flight ?

For any given flight there could be several seats and there should be some information about the status of the seats on that flight for a given date .

Does this information belogs to Segment table ?
I don't think so as segment table is very specific to segment .

does this belongs to flight table ?
Depends how the flight table is designed . If the flight table is independent of the date then it cannot have seats information for a particular date

Does it belong to seat table ?
Possible . But there could be several records . seat table could have information about each seat for each flight for a given date.

So if a given flight with 200 seats fly on each day of the year then seat table could have Information about each seat .

For optimization this information can be stored as a blob containig list of available seats.

Any thoughts ?

Thanks
Sangita

[Joseph Zhou]

Hi Sangita,
When the tickets of a given flight(one take off and land) on the list for sale, we need a Flight object. For constrcting the object, we need info like segment, datetime, equipmentId(same 737 may have different setting) etc. the seat set decided by equipmentId. the status of a seat could be changed before it take off. obviously, the object nedd to be persisted to DB.