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