ㅁㄴㅇ

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