편의점

테이블 (6)

discard_products

  • product_code — number(12) — 외래 키 → products.product_code
  • product_qty — NUMBER(3)
  • discard_date — DATE

membership

  • member_num — NUMBER(8) — 기본 키
  • member_card — VARCHAR2(20) — NOT NULL
  • member_join — DATE
  • member_point — NUMBER(6)

po_management (puchase_order)

  • product_code (product_code2) — number(12) — 외래 키 → products.product_code
  • product_code — number(12)
  • product_name — VARCHAR2(50)
  • product_qty — NUMBER(3)
  • total_amounts — NUMBER(20)
  • po_date — DATE

products

  • product_code — number(12) — 기본 키
  • product_name — VARCHAR2(30) — NOT NULL
  • price — number(6) — NOT NULL
  • manufacturing_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • inhouse_date — DATE — NOT NULL

sales

  • saleNum — number(20) — 기본 키
  • buyDate — DATE — NOT NULL
  • member_num — NUMBER(8)
  • SALES_AMOUNT — number(20) — NOT NULL
  • product_name (Field) — VARCHAR(255) — NOT NULL
  • member_num (member_num2) — NUMBER(8) — 외래 키 → membership.member_num

sales_record

  • product_code (product_code2) — number(12) — 외래 키 → products.product_code
  • saleNum (saleNum2) — number(20) — 외래 키 → sales.saleNum
  • amount — number(4) — NOT NULL
  • saleNum — number(20)