likelion_HW1

Tables (4)

menus (가게메뉴)

  • menu_id (메뉴고유번호) — INT — Primary key — NOT NULL
  • stores_id (가게고유아이디) — INT — Foreign key → stores.stores_id — NOT NULL
  • menu_name (메뉴이름) — VARCHAR
  • menu_price (메뉴가격) — VARCHAR
  • menu_image (메뉴사진)

stores (가게)

  • stores_id (가게고유아이디) — INT — Primary key — NOT NULL
  • storename (가게이름) — VARCHAR
  • store_address (가게주소) — VARCHAR
  • store_introduce (가게소개) — VARCHAR
  • store_number (가게전화번호) — VARCHAR
  • store_stars (가게별점) — INT
  • store_time (가게운영시간) — VARCHAR

user_orderd (사용자주문기록)

  • id_key (사용자고유번호) — INT — Foreign key → users.id_key
  • stores_id (가게고유아이디) — INT — Foreign key → stores.stores_id — NOT NULL
  • order_time (주문시각) — DATETIME
  • order_menu (주문메뉴) — VARCHAR
  • order_price (주문가격) — INT
  • order_require (주문요청사항) — VARCHAR
  • order_payment (주문결재방식) — VARCHAR

users (사용자)

  • id_key (사용자고유번호) — INT — Primary key
  • username (사용자명) — VARCHAR
  • userid (사용자아이디) — VARCHAR
  • userpw (비밀번호) — VARCHAR
  • address (주소) — VARCHAR
  • ordered (주문여부) — BOOLEAN