공연예매
테이블 (5)
blacklist
- id — bigint — NOT NULL
- member — bigint — NOT NULL
- room — bigint — NOT NULL
- registration_date — timestamp
email_auth
- id — bigint — NOT NULL
- member — bigint — NOT NULL
- expiration_status — boolean — NOT NULL
- expiration_date — timestamp — NOT NULL
member
- id — bigint — NOT NULL
- rating — int — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- phone_number — varchar(13) — NOT NULL
- nickname — varchar(16) — NOT NULL
- registered_date — timestamp — NOT NULL
- modified_date — timestamp
- withdrawal_date — timestamp
- permission — varchar(16) — NOT NULL
- email_auth — boolean — NOT NULL
- sanction_whether — boolean — NOT NULL
reservation
- id — bigint — NOT NULL
- performance_schedule — bigint — NOT NULL
- member — bigint — NOT NULL
- reservation_date — timestamp — NOT NULL
- performance_name — varchar(100) — NOT NULL
- performance_date — timestamp — NOT NULL
- ticket_quantity — int — NOT NULL
- reservation_status — varchar(30) — NOT NULL
review
- id — bigint — NOT NULL
- member — bigint — NOT NULL
- reservation — bigint — NOT NULL
- title — varchar(50) — NOT NULL
- content — varchar(1000) — NOT NULL