FIESTA
Tables (10)
BOOTH (부스)
- BoothID (Key) — int(8) — Primary key — NOT NULL
- CreatedAt (Field7) — datetime
- ModifiedAt (Field6) — datetime
- Name (Field3) — varchar(20) — NOT NULL
- BoothCode (Field2) — int(4) — NOT NULL
- Location (Field) — varchar(50) — NOT NULL — ** 부스 위치
- Type (Field5) — binary — NOT NULL — ** 0이 낮 1이 밤 부스
- Detail (Field4) — text — ** 부스 설명
- Date (Field8) — date — NOT NULL — ** 부스 운영 날짜
- BoothState (Field9) — binary — NOT NULL — 부스 IS 등록 여부(활성화 여부)
- StaffID (Key2) — int(8) — Foreign key → STAFF_BANK.StaffID — NOT NULL
MENU (메뉴)
- MenuID (Key) — int(8) — Primary key — NOT NULL
- BoothID (Key2) — int(8) — Foreign key → BOOTH.BoothID — NOT NULL
- CreatedAt (Field4) — datetime
- ModifiedAt (Field3) — datetime
- Name (Field) — varchar(20) — NOT NULL
- Price (Field2) — bigint — NOT NULL
ORDER (주문)
- OrderID (Key) — int(8) — Primary key — NOT NULL
- BoothID (Key2) — int(8) — Foreign key → BOOTH.BoothID — NOT NULL
- UserID (Key22) — int(8) — Foreign key → USER_BANK.UserID — NOT NULL
- CreatedAt (Field) — datetime
- TableNumber (Field2) — tinyint — NOT NULL
- TotalPrice (Field4) — bigint — NOT NULL
ORDER_MENU (주문_메뉴)
- OrderID (Key2) — int(8) — Foreign key → ORDER.OrderID — NOT NULL
- MenuID (Key3) — int(8) — Foreign key → MENU.MenuID — NOT NULL
- BoothID (Key22) — int(8) — Foreign key → MENU.BoothID — NOT NULL
- State (Field) — binary — NOT NULL
- Amount (Field2) — tinyint — NOT NULL
POST (게시물)
- PostID (Key) — int(8) — Primary key — NOT NULL
- CreatedAt (Field) — datetime
- ModifiedAt (Field4) — datetime
- Title (Field2) — varchar(100) — NOT NULL
- Detail (Field3) — longtext
STAFF (스태프)
- StaffID (Key) — int(8) — Primary key — NOT NULL
- BoothID (Key2) — int(8) — Foreign key → BOOTH.BoothID — NOT NULL
- ModifiedAt (Field5) — datetime
- CreatedAt (Field3) — datetime
- Password (Field) — varchar(20) — NOT NULL
- E-mail (Field2) — varchar(30) — NOT NULL
- Priority (Field4) — binary — 0이 1st staff, 1이 2nd staff
STAFF_BANK (스태프_은행)
- StaffID (Key2) — int(8) — Foreign key → STAFF.StaffID — NOT NULL
- Bank (Field) — varchar(10) — NOT NULL
- BankAccount (Field2) — varchar(15) — NOT NULL
- BankBalance (Field4) — bigint — NOT NULL
TRANSACTION (Untitled)
- UserID (Key2) — int(8) — Foreign key → USER_BANK.UserID — NOT NULL
- StaffID (Key22) — int(8) — Foreign key → STAFF_BANK.StaffID — NOT NULL
- PaymentAmount (Field) — bigint — NOT NULL — Order.TotalPrice 금액과 동일
USER (유저)
- UserID (Key) — int(8) — Primary key — NOT NULL
- CreatedAt (Field2) — datetime — 생성일시
- ModifiedAt (Field3) — datetime — 수정일시
- Name (Field5) — varchar(20) — NOT NULL
- E-mail (Field4) — varchar(30) — NOT NULL — 로그인시 ID로 사용 , unique
- Password (Field) — varchar(20) — NOT NULL — 8 자 이상
USER_BANK (유저 은행 정보)
- UserID (Key2) — int(8) — Foreign key → USER.UserID — NOT NULL
- Bank (Field3) — varchar(10) — NOT NULL
- BankAccount (Field) — varchar(15) — NOT NULL
- BankBalance (Field2) — bigint — NOT NULL