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