21.09 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
Sept 13, 2021
1 min read
Loading data...
Deleted table(s)
[tbl_Batch_Header]
[tbl_BatchHeader_Charges_XREF]
[tbl_BatchHeader_Payments_XREF]
[tbl_Quick_Ticket_Fare_Detail]
[tbl_Quick_Ticket_Fare_Detail_Fare_Header_Xref]
[tbl_Quick_Ticket_Fare_Detail_Pax_Company_Xref]
[tbl_Quick_Tickets]
[tbl_QuickTickets_GLPayments_Xref]
Added table(s)
[tbl_Res_Pending_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Res_Pending_Xref_Id_Nmbr] | BIGINT | NO |
| [lng_Reservation_Nmbr] | INT | NO |
| [str_Guid] | VARCHAR (62) | NO |
| [lng_GL_Payment_Method_Id_Nmbr] | INT | NO |
| [mny_Payment_Amt] | MONEY | NO |
| [mny_Payment_Process_Fee_Amt] | MONEY | NO |
| [str_Pending_Status] | CHAR (1) | NO |
| [bit_Pending_Lock] | BIT | NO |
| [dtm_Pending_Lock_Expiry_Date] | SMALLDATETIME | YES |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | NO |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
Added column(s)
[tbl_3rd_Party_Pmt_Type_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
| [bit_Allow_Multiple] | BIT | NO |
| [bit_Lock_Pending] | BIT | NO |
[tbl_ECATS3_Sent_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [mny_WS_Dep_Enplaned_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Dep_Transiting_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Arr_Deplaned_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Arr_Transiting_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Dep_Enplaned_Mail] | MONEY | NO |
| [mny_WS_Dep_Transiting_Mail] | MONEY | NO |
| [mny_WS_Arr_Deplaned_Mail] | MONEY | NO |
| [mny_WS_Arr_Transiting_Mail] | MONEY | NO |
[tbl_Res_Segments_Pending]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Distribution_Channel_Ident] | VARCHAR (2) | YES |
| [bit_Involuntary_Change] | BIT | NO |
| [str_Guid] | VARCHAR (62) | YES |
[tbl_Seat_Assignment_Reservation]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid] | VARCHAR (62) | NO |
[tbl_Seat_Assignment_Reservation_Verification_Hold]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid] | VARCHAR (62) | NO |
[tbl_Sked_Detail_Weight]
Field | Data Type | NULLABLE |
|---|---|---|
| [mny_Departure_Enplaned_Freight] | MONEY | NO |
| [mny_Departure_Transiting_Freight] | MONEY | NO |
| [mny_Arrival_Deplaned_Freight] | MONEY | NO |
| [mny_Arrival_Transiting_Freight] | MONEY | NO |
| [mny_Departure_Enplaned_Mail] | MONEY | NO |
| [mny_Departure_Transiting_Mail] | MONEY | NO |
| [mny_Arrival_Deplaned_Mail] | MONEY | NO |
| [mny_Arrival_Transiting_Mail] | MONEY | NO |
Deleted column(s)
[tbl_ECATS3_Sent_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_WS_Dep_Enplaned_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Dep_Transiting_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Arr_Deplaned_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Arr_Transiting_Freight_Kg_Rev] | INT | NO |
[tbl_GL_Non_Res_Payments_Refund]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Refund_Notes] | VARCHAR (50) | NO |
Modified column(s)
[tbl_GL_Non_Res_Payments]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Payments_Notes] | VARCHAR (250) | NO |
[tbl_GL_Payments]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Payments_Notes] | VARCHAR (250) | NO |
[tbl_Non_Reservation_3rd_Party_Payment_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid_Id] | NVARCHAR (62) | NO |
[tbl_Reservation_3rd_Party_Payment_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid_Id] | NVARCHAR (62) | NO |