퍼포미야_CONTROLLER
테이블 (3)
Controller
- controller_id — varchar2(15) — 기본 키 — NOT NULL
- controller_password — varchar(20) — NOT NULL
Join
- user_id — varchar2(15) — 기본 키 — NOT NULL
- controller_id — varchar2(15) — 외래 키 → Controller.controller_id — 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
- controller_id — varchar2(15) — 외래 키 → Controller.controller_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