cafe

Tables (5)

CAFE

  • cafe_id — INT
  • user_id — INT — NOT NULL
  • cafe_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL

CATEGORY

  • category_id — INT
  • cafe_id — INT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

MENU

  • menu_id — INT
  • cafe_id — INT — NOT NULL
  • category_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • is_available — TINYINT — NOT NULL

ORDERS

  • order_id — INT
  • user_id — INT — NOT NULL
  • cafe_id — INT — NOT NULL
  • status — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

USER (사용자)

  • user_id (사용자 식별자) — Primary key — NOT NULL — autoincrement
  • user_type (유저 종류(관리자/유저)) — NOT NULL — 관리자는 1 유저는 0
  • password (사용자 비밀번호) — NOT NULL
  • nickname (사용자 닉네임) — NOT NULL
  • phone (사용자 전화버호) — NOT NULL
  • business_number (사업자 번호) — 선택입력
  • birth (생년월일) — NOT NULL