ㅁㄴㅇ
Tables (8)
Untitled
- Air_num — NUMBER(6) — Primary key — NOT NULL
- Air_code — INTEGER — NOT NULL
- Air_name — VARCHAR2(30)
Untitled11
- User_id — VARCHAR2(20) — Primary key — NOT NULL
- User_pw — VARCHAR2(20)
- User_name — VARCHAR2(10)
- User_tel — VARCHAR2(20)
Untitled3
- Plane_name — VARCHAR2(30) — Primary key — NOT NULL
- Plane_price — NUMBER(10, 2)
- Plane_people — NUMBER(6)
Untitled4
- Airport_name — VARCHAR2(20) — Primary key — NOT NULL
- Airport_cn — VARCHAR2(20)
Untitled6
- Date_num — INTEGER — Primary key — NOT NULL
- Plane_name — VARCHAR2(30) — Foreign key → Untitled3.Plane_name — NOT NULL
- Air_num — NUMBER(6) — Foreign key → Untitled.Air_num — NOT NULL
- Airport_name — VARCHAR2(20) — Foreign key → Untitled4.Airport_name
- Start_time — DATE
- End_time — DATE
- Start_date — DATE
Untitled7
- Ticket_num — INTEGER — Primary key — NOT NULL
- Setafter_num — INTEGER — Foreign key → Untitled9.Setafter_num — NOT NULL
- Date_num — INTEGER — Foreign key → Untitled6.Date_num — NOT NULL
- Plane_name2 — VARCHAR2(30) — Foreign key → Untitled6.Plane_name — NOT NULL
- Air_num — NUMBER(6) — Foreign key → Untitled6.Air_num — NOT NULL
- User_id2 — VARCHAR2(20) — Foreign key → Untitled11.User_id — NOT NULL
- Airport_name — VARCHAR2(20) — Foreign key → Untitled6.Airport_name
- Ticket_date — DATE
- Ticket_price — INTEGER
- User_id — INTEGER
- Pp_num — INTEGER
- User_num — INTEGER — NOT NULL
Untitled8
- Set_num — INTEGER — Primary key — NOT NULL
- Plane_name — VARCHAR2(30) — Foreign key → Untitled3.Plane_name — NOT NULL
- Set_grade — INTEGER
- Set_name — INTEGER
Untitled9
- Setafter_num — INTEGER — Primary key — NOT NULL
- Set_num — INTEGER — Foreign key → Untitled8.Set_num — NOT NULL
- Plane_name — VARCHAR2(30) — Foreign key → Untitled8.Plane_name — NOT NULL