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