meat
Tables (4)
CUSTOMER (고객 정보)
- CUSTOMER_NUM (Key) — STRING — Primary key — NOT NULL
- CUSTOMER_BIRTHDAY (Field) — DATE
- CUSTOMER_ID (Field2) — STRING
- CUSTOMER_PASSWORD (Field3) — STRING
- CUSTOMER_PHONE_NUMBER (Field4) — STRING
MEAT (고기 정보)
- MEAT_NUM (Key) — INT — Primary key — NOT NULL
- MEAT_NAME (Field) — STRING
- MEAT_PART (Field2) — STRING
- MEAT_RECIPES (Field3) — STRING
- AVERAGE_PRICE_PER_KG (Field4) — DOUBLE
- SEASONALITY (Field5) — STRING
ORDER_HISTORY (주문 내역)
- ORDER_NUM (Key) — STRING — Primary key — NOT NULL
- CUSTOMER_NUM (Key2) — STRING — Foreign key → CUSTOMER.CUSTOMER_NUM — NOT NULL
- MEAT_NUM (Key3) — INT — Foreign key → MEAT.MEAT_NUM — NOT NULL
- ORDER_DATE (Field) — DATE
- ORDER_QUANTITY (Field2) — INT
- ORDER_DELIVERY_ADDRESS (Field3) — STRING
SALES_STATISTICS (매출 통계)
- STAT_DATE (Key) — DATE — Primary key — NOT NULL
- MEAT_NUM (Key2) — INT — Foreign key → MEAT.MEAT_NUM — NOT NULL
- TOTAL_QUANTITY (Field2) — INT
- TOTAL_REVENUE (Field3) — DOUBLE