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