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