KNU_Coin
Tables (8)
customer (고객정보)
- customer_id (고객ID) — varchar(30) — Primary key — NOT NULL
- customer_pw (고객PW) — varchar(30)
- customer_name (고객이름) — varchar(30)
- customer_phone (고객전화번호)
customer_coin (고객코인)
- customer_id (고객ID) — varchar(30) — Foreign key → customer.customer_id — NOT NULL
- coin_knu (실제코인)
- coin_event (이벤트코인)
operator (운영자)
- operator_id (운영자ID) — varchar(30) — Primary key — NOT NULL
- store_id (매장id) — varchar(30) — Foreign key → store.store_id — NOT NULL
- store_coin (매장코인)
- operator_pw (운영자PW)
operator_coin (운영자 코인)
- operator_id (운영자ID) — varchar(30) — Foreign key → operator.operator_id — NOT NULL
- store_id (매장id) — varchar(30) — Foreign key → operator.store_id — NOT NULL
- coin_knu (실제코인)
- coin_event (이벤트코인)
orderlist (주문내역)
- order_id (오더번호) — Primary key — NOT NULL
- store_id (매장id) — varchar(30) — Foreign key → store.store_id — NOT NULL
- customer_id (고객ID) — varchar(30) — Foreign key → customer.customer_id — NOT NULL
- menu_name (메뉴명) — Foreign key → store_menu.menu_name — NOT NULL
- menu_quantity (메뉴수량)
- order_price (가격)
- requirement (요구사항)
- order_time (주문시간)
payment (결제)
- Key (오더번호) — Primary key — NOT NULL
- customer_id (고객ID) — varchar(30) — Foreign key → customer_coin.customer_id — NOT NULL
- operator_id (운영자ID) — varchar(30) — Foreign key → operator_coin.operator_id — NOT NULL
- store_id (매장id) — varchar(30) — Foreign key → operator_coin.store_id — NOT NULL
- Field (거래코인)
store (매장정보)
- store_id (매장id) — varchar(30) — Primary key — NOT NULL
- store_open (오픈시간)
- store_close (마감시간)
- store_name (매장이름)
store_menu (주문)
- menu_name (메뉴명) — Primary key — NOT NULL
- store_id (매장id) — varchar(30) — Foreign key → store.store_id — NOT NULL
- menu_price (가격)
- menu_size (사이즈)