typeScript개인과제
테이블 (4)
Show (Untitled2)
- id — integer(bigint) — 기본 키 — NOT NULL
- name — varchar — NOT NULL
- category — enum — NOT NULL
- intro — text
- photos — text
- content — text — NOT NULL
- actors — text — NOT NULL
- price — integer — NOT NULL
- firstShow — datetime — NOT NULL
- lastShow — datetime — NOT NULL
- theatre — NOT NULL
User (Untitled)
- id — integer(bigint) — 기본 키
- email — varchar — NOT NULL
- password — varchar — NOT NULL
- name — varchar — NOT NULL
- nickname — varchar — NOT NULL
- phone — varchar — NOT NULL
- preference — enum
- point — integer — NOT NULL
reservation (CopyOfUntitled3)
- id — integer — 기본 키 — NOT NULL
- id (id2) — integer(bigint) — 외래 키 → Show.id — NOT NULL
- id (id3) — integer(bigint) — 외래 키 → User.id
- user_name — varchar — NOT NULL
- user_nickname — varchar — NOT NULL
- show_name — varchar — NOT NULL
- theatre — varchar — NOT NULL
- seat — integer — NOT NULL
- price — integer — NOT NULL
- date — NOT NULL — 공연 날짜
theatre (Untitled3)
- id — integer — 기본 키 — NOT NULL
- id (id2) — integer(bigint) — 외래 키 → Show.id — NOT NULL
- id (id3) — integer — 외래 키 → reservation.id — NOT NULL
- name — varchar — NOT NULL
- seats — integer — NOT NULL
- seat_max — integer — NOT NULL