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 (사이즈)