concert
Tables (7)
CONCERT (콘서트)
- CONCERT_ID (Key) — BIGINT — Primary key — NOT NULL
- NAME (이름) — VARCHAR
CONCERT_SCHEDULE (콘서트 스케줄)
- CONCERT_SCHEDULE_ID (Key) — Primary key — NOT NULL
- CONCERT_ID (콘서트ID) — BIGINT — Foreign key → CONCERT.CONCERT_ID — NOT NULL
- SCHEDULE_DT (콘서트일시) — DATETIME
- Field
CONCERT_SEAT (좌석)
- SEAT_ID (Key) — Primary key — NOT NULL
- CONCERT_SCHEDULE_ID (Key2) — Foreign key → CONCERT_SCHEDULE.CONCERT_SCHEDULE_ID — NOT NULL
- NUMBER (Field)
- STATUS (Field2)
- PRICE (Field3)
QUEUE (대기열)
- QUEUE_ID (Key) — BIGINT — Primary key — NOT NULL
- USER_ID (유저아이디) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- CONCERT_SCHEDULE_ID (Key2) — Foreign key → CONCERT_SCHEDULE.CONCERT_SCHEDULE_ID — NOT NULL
- TOKEN (토큰값) — VARCHAR
- STATUS (상태) — TINYINT
- REG_DT (발급일시) — DATETIME
- EXP_DT (만료일시) — DATETIME
USER (사용자)
- USER_ID (Key) — BIGINT — Primary key — NOT NULL
- BALANCE (잔액)