Artique
Tables (3)
User (사용자)
- Key — varchar(255) — Primary key — NOT NULL
- nickname (Field) — varchar(255)
- profile (Field2)
- introduce (Field3)
- password (Field4) — varchar(255)
musical (뮤지컬(연극))
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(255)
- begin_date (Field2) — datetime(6)
- end_date (Field6) — datetime(6)
- place_name (Field3) — varchar(255)
- genre (Field4) — varchar(255)
- casting (Field5) — varchar(255)
- running_time (Field7) — int
- plot (Field8) — text
- poster (Field9) — varchar(255)
review (리뷰)
- id (Key) — bigint — Primary key — NOT NULL
- star_rating (Field) — int
- short_review (Field2) — text
- long_review (Field3) — text
- casting (Field4) — varchar(255)
- view_date (Field5) — datetime(6)
- seat (Field6) — varchar(255)
- like (Field7) — bigint
- Key (Key2) — varchar(255) — Foreign key → User.Key — NOT NULL
- id (Key3) — bigint — Foreign key → musical.id — NOT NULL