TIGGLE 수정

테이블 (20)

admin

  • adminid — VARCHAR(255) — 기본 키 — NOT NULL
  • id — varchar(20)
  • password — varchar(100)

book

  • reservationId — int — 기본 키 — NOT NULL
  • memberId — int — 외래 키 → user.memberId — NOT NULL
  • seatId — 외래 키 → seat.seatId — NOT NULL
  • requestExchange — varchar(20)
  • reservationNumber — varchar(30)
  • createdAt — datetime
  • payMethod — varchar(20)
  • price — int
  • pointPayment — int

category

  • categoryId — int — 기본 키 — NOT NULL
  • categoryName — varchar

chat

  • chatId — int — 기본 키 — NOT NULL
  • Field — varchar(200)
  • createdAt — datetime

chatroom

  • chatbotId — int — 기본 키 — NOT NULL
  • createdAt — datetime
  • content — varchar(200)

date

  • date — 기본 키 — NOT NULL
  • programId — int — 외래 키 → program.programId — NOT NULL
  • times

event

  • eventId — VARCHAR(255) — 기본 키 — NOT NULL
  • eventName — VARCHAR(255)
  • eventContent — VARCHAR(255)
  • eventDate — VARCHAR(255)
  • Field — VARCHAR(255)

event_user

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • eventId — VARCHAR(255) — NOT NULL

exchage (exchange)

  • exchangeId — int — 기본 키 — NOT NULL
  • reservationId1 — int — 외래 키 → book.reservationId — NOT NULL
  • reservationId2 — int — 외래 키 → book.reservationId — NOT NULL
  • programId — int — 외래 키 → program.programId — NOT NULL
  • count — int
  • isSuccesed
  • changedAt

grade

  • gradeId — int — 기본 키 — NOT NULL
  • programId — int — 외래 키 → program.programId — NOT NULL
  • grade — varchar(5)
  • price — int

like

  • likeId — VARCHAR(255) — 기본 키 — NOT NULL
  • memberid — VARCHAR(255) — NOT NULL
  • cinemaId — VARCHAR(255) — NOT NULL

location

  • areaId — int — 기본 키 — NOT NULL
  • name — varchar(20)
  • si — varchar(20)
  • gu — varchar(20)
  • address — varchar(50)
  • x — int
  • y — int
  • seatImg — varchar(100)
  • photo — varchar(100)

point

  • pointId — 기본 키 — NOT NULL
  • value
  • usingDate
  • getOrLose
  • total

program

  • programId — int — 기본 키 — NOT NULL
  • areaId — int — 외래 키 → location.areaId — NOT NULL
  • categoryId — int — 외래 키 → category.categoryId — NOT NULL
  • programName — varchar(100)
  • programInfo — text
  • bookableDate — datetime
  • bookingEndDate — datetime
  • imgUrl — varchar(100)
  • age — int
  • runtime — int
  • salerInfo — text
  • createdAt — datetime
  • modifiedAt — datetime

review_exchange

  • exReviewId — int — 기본 키 — NOT NULL
  • exchangeId — int — 외래 키 → exchage.exchangeId — NOT NULL
  • content — text
  • createdAt — datetime
  • star — int

review_performance

  • reviewId (pfReviewId) — int — 기본 키 — NOT NULL
  • reservationId (reservationId2) — int — 외래 키 → book.reservationId — NOT NULL
  • content — text
  • createdAt — datetime
  • star — int

rule

  • ruleId — int — 기본 키 — NOT NULL
  • programId — int — 외래 키 → program.programId — NOT NULL
  • notice — text

seat

  • seatId — 기본 키 — NOT NULL
  • date — 외래 키 → date.date — NOT NULL
  • section
  • grade
  • seatStatus (seattStatus)

section

  • sectionId — int — 기본 키 — NOT NULL
  • areaId — int — 외래 키 → location.areaId — NOT NULL
  • section — varchar(5)
  • seatCount — int

user

  • memberId — int — 기본 키 — NOT NULL
  • name — varchar(20)
  • email — email
  • id — varchar(20)
  • password — varchar(100)
  • address — varchar(50)
  • createdAt — datetime
  • modifiedAt — datetime
  • loginType — varchar(20)
  • status — varchar(100)
  • pointId — 외래 키 → point.pointId — NOT NULL