online-reservation-project

Tables (5)

Performance (pref) (공연)

  • perf_id (공연ID) — int — Primary key — NOT NULL
  • perf_name (이름) — varchar(45) — NOT NULL
  • perf_description (설명) — varchar(400) — NOT NULL
  • perf_category (Field3) — varchar(45) — NOT NULL
  • perf_price (가격) — int — NOT NULL — 최대 50,000p
  • perf_address (Field) — varchar(45) — NOT NULL
  • perf_image (Field2) — varchar(200)
  • created_At (업로드 시간) — timestamp — NOT NULL
  • updated_At (수정 시간) — timestamp — NOT NULL

PerformanceDetail(prefd) (Untitled)

  • perfd_id (Key) — int — Primary key — NOT NULL
  • Perf_id (공연ID) — int — Foreign key → Performance (pref).perf_id — NOT NULL
  • date (Field) — varchar(45) — NOT NULL
  • time (Field2) — varchar(45) — NOT NULL

Reservation (res) (예매)

  • res_id (예매ID) — int — Primary key — NOT NULL
  • User_id (유저ID) — int — Foreign key → User.user_id — NOT NULL
  • Pref_id (공연ID) — int — Foreign key → Performance (pref).perf_id — NOT NULL
  • Seat_id (좌석ID) — int — Foreign key → Seat.seat_id — NOT NULL
  • Perfd_id (Field3) — int — NOT NULL
  • price (Field) — int — NOT NULL
  • created_At (Field2) — timestamp — NOT NULL

Seat (좌석)

  • seat_id (좌석ID) — int — Primary key — NOT NULL
  • Perfd_id (Key) — int — Foreign key → PerformanceDetail(prefd).perfd_id — NOT NULL
  • seat_row (열) — varcher(1) — NOT NULL — A~D
  • seat_num (번호) — int — NOT NULL
  • seat_reservation (예매여부) — tinyint(1) — NOT NULL

User (사용자)

  • user_id (유저ID) — int — Primary key — NOT NULL
  • user_email (아이디) — varchar(100) — NOT NULL
  • user_password (비밀번호) — varchar(200) — NOT NULL — 암호화
  • user_name (이름) — varchar(45) — NOT NULL
  • user_point (포인트) — int — NOT NULL — 단위: p
  • user_image (사진) — varchar(100)
  • is_admin (Field) — tinyint(1) — NOT NULL — true 일시 admin