퍼포미야_USER
테이블 (5)
Join
- user_id — varchar2(15) — 기본 키 — NOT NULL
- user_name — varchar(10) — NOT NULL
- user_nickname — varchar2(20) — NOT NULL
- user_password — varchar(20) — NOT NULL
Musical
- musical_Kortitle — varchar2(100) — 기본 키 — NOT NULL
- user_id — varchar2(15) — 외래 키 → Join.user_id — NOT NULL
- musical_Entitle — varchar2(100)
- musical_performer — varchar2(100) — NOT NULL
- musical_age — int — NOT NULL
- musical_story — varchar2(255) — NOT NULL
- musical_place_url — varchar2(125)
- musical_startDate — date — NOT NULL
- musical_endDate — date — NOT NULL
- musical_price — int — NOT NULL
- musical_image — varchar2(100) — NOT NULL
- musical_type — varchar2(2) — NOT NULL
Poster
- poster_title — varchar2(100) — 기본 키 — NOT NULL
- poster_image — varchar2(100) — NOT NULL
- poster_explain — varchar2(255) — NOT NULL
Reserve
- reserve_pin — varchar2(20) — 기본 키 — NOT NULL
- user_id — varchar2(15) — 외래 키 → Join.user_id — NOT NULL
- reserve_title — varchar2(100) — NOT NULL
- reserve_seat — varchar2(20) — NOT NULL
- reserve_date — date — NOT NULL
- reserve_time — time — NOT NULL
- reserve_price — int — NOT NULL
Review
- review_title — varchar2(100) — 기본 키 — NOT NULL
- user_id — varchar2(15) — 외래 키 → Join.user_id — NOT NULL
- user_nickname — varchar2(20) — NOT NULL
- review_context — varchar2(255) — NOT NULL
- review_date — date — NOT NULL
- review_star — varchar2(5) — NOT NULL
- review_count — int — NOT NULL
- review_number — int — NOT NULL