편의점
테이블 (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)