concert

Tables (7)

AMOUNT_HISTORY (잔액 내역)

    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

    SEAT_RESERVATION (좌석 예약)

      USER (사용자)

      • USER_ID (Key) — BIGINT — Primary key — NOT NULL
      • BALANCE (잔액)