공연예매

테이블 (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