DB_hw

Tables (4)

Movie

  • Name (id) — NUMBER — Primary key — NOT NULL — 트리거를 이용해 autoincreament를 적용
  • Field (name) — VARCHAR(255) — NOT NULL

Untitled (TimeLine)

  • Key (id) — NUMBER — Primary key — NOT NULL — 트리거를 이용해 autoincreament를 적용
  • Name (movie_id) — NUMBER — Foreign key → Movie.Name — NOT NULL — on delete cascade
  • Field (screendate) — DATE — NOT NULL
  • Field (hour) — NUMBER(2) — NOT NULL
  • Field (minute) — NUMBER(2) — NOT NULL

Untitled (Reservation)

  • Key (timeline_id) — NUMBER — Foreign key → Untitled.Key — NOT NULL — on delete no action 은 디폴트로 들어가 있음.
  • id (user_id) — VARCHAR(100) — Foreign key → User.id — NOT NULL — on delete no action 은 디폴트로 들어가 있음.
  • Field (line) — VARCHAR(1) — NOT NULL
  • Field2 (col) — VARCHAR(2) — NOT NULL

User

  • id — VARCHAR(100) — Primary key — NOT NULL
  • pwd — VARCHAR(255) — NOT NULL
  • Field (name) — VARCHAR(255) — NOT NULL
  • Field2 (birthdate) — DATE
  • Field (cellphone) — VARCHAR(11)
  • Field (type) — VARCHAR(10) — NOT NULL — default: normal