PosSystem

Tables (7)

BUYLIST (CATEGORY (카테고리))

  • Key (ID) — Primary key — NOT NULL
  • CHECK_D (NAME) — NOT NULL
  • Field (IMG) — NOT NULL

Copy Of BUYLIST (SALES (구매목록))

  • Key (ID) — Primary key — NOT NULL
  • ID (RECEIPT_ID) — Foreign key → ORDER.ID — NOT NULL
  • Key (STOCK_ID) — Foreign key → Copy Of ORDER.Key — NOT NULL
  • CHECK_D (NUM) — NOT NULL
  • NUM (TOTAL_PRICE) — NOT NULL

Copy Of ORDER (Stock (재고))

  • Key (ID) — Primary key — NOT NULL
  • ID (PRODUCT_ID) — Foreign key → ITEMS.ID — NOT NULL
  • Key (STORE_ID) — Foreign key → SELLER.Key — NOT NULL
  • BUY_DATE (QT) — NOT NULL

ITEMS (Product (상품))

  • ID — Primary key — NOT NULL
  • Key (CATEGORY_ID) — Foreign key → BUYLIST.Key — NOT NULL
  • NAME — NOT NULL
  • PRICE — NOT NULL

ORDER (RECEIPT (영수증))

  • ID — Primary key — NOT NULL
  • ID (CUS_ID) — Foreign key → USER.ID — NOT NULL
  • Key (STORE_ID) — Foreign key → SELLER.Key — NOT NULL
  • BUY_DATE (S_DATE) — NOT NULL
  • TOTAL — NOT NULL

SELLER (STORE (지점정보))

  • Key (ID) — Primary key — NOT NULL
  • INFO (NAME)
  • Field (LAT)
  • Field (LON)
  • Field (LOCATION)

USER (CUSTOMER (구매자))

  • ID — Primary key — NOT NULL
  • PWD (PAYMENT) — NOT NULL