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