FLIGHT RESERVATION
Tables (8)
air_craft
- c_id — BIGSERIAL — Primary key
- c_name — VARCHAR(255)
- c_line — VARCHAR(255)
- c_seat — BIGINT
- c_model — VARCHAR(255)
airport
- a_id — BIGSERIAL — Primary key
- a_code — VARCHAR(10)
- a_namek — VARCHAR(255) — NOT NULL
- continent — VARCHAR(255) — NOT NULL
airport2
- a_id — BIGSERIAL — Primary key
- a_code — VARCHAR(10)
- a_namek — VARCHAR(255) — NOT NULL
- continent — VARCHAR(255) — NOT NULL
deleted_reservation
- id — BIGSERIAL — Primary key
- u_id — BIGINT
- group_id — VARCHAR(255)
- reason — TEXT
- deleted_at — TIMESTAMP
- is_checked — BOOLEAN — NOT NULL
flight_info
- f_id — BIGSERIAL — Primary key
- aircraft_id (c_id) — BIGINT — Foreign key → air_craft.c_id
- departure_airport_id (a_id) — BIGINT — Foreign key → airport.a_id
- arrival_airport_id (a_id2) — BIGINT — Foreign key → airport2.a_id
- f_de_time — TIMESTAMP — NOT NULL
- f_ar_time — TIMESTAMP — NOT NULL
- f_seat — INTEGER — NOT NULL
payment
- payment_id — BIGSERIAL — Primary key
- u_id — BIGINT — NOT NULL
- price — INTEGER — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
reservation
- r_id — BIGSERIAL — Primary key
- payment_id — BIGINT — Foreign key → payment.payment_id
- u_id — BIGINT — NOT NULL
- f_id — BIGINT — NOT NULL
- r_date — TIMESTAMP — NOT NULL
- f_departure — VARCHAR(255) — NOT NULL
- f_arrival — VARCHAR(255) — NOT NULL
- f_departure_time — TIMESTAMP — NOT NULL
- f_arrival_time — TIMESTAMP — NOT NULL
- c_id — BIGINT
- f_aircraft_type — VARCHAR(255) — NOT NULL
- u_name — VARCHAR(255) — NOT NULL
- s_name — VARCHAR(255) — NOT NULL
- s_spot — VARCHAR(255) — NOT NULL
- s_class — VARCHAR(255) — NOT NULL
- ticket_price — INTEGER — NOT NULL
- group_id — VARCHAR(255) — NOT NULL
users
- id — BIGSERIAL — Primary key
- user_first_name — VARCHAR(255) — NOT NULL
- user_last_name — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(50) — NOT NULL
- birthday — DATE
- created_at — TIMESTAMP
- address — VARCHAR(255)
- deleted_at — TIMESTAMP
- admin — BOOLEAN — NOT NULL