hi

Tables (4)

InventoryManagement (Untitled2)

  • 재고번호 (inventory_num) — NUMBER(8) — Primary key — NOT NULL
  • 상품명 (Field)
  • Field2
  • Field3
  • Field4
  • Field5

Membership (회원 테이블)

  • 회원넘버 (member_num) — NUMBER(8) — Primary key — NOT NULL
  • 회원카드번호 (member_card) — VARCHAR2(20)
  • 발급일자 (member_join) — SYSDATE
  • 잔여포인트 (member_point) — NUMBER(6)

ProductManagement (Untitled)

  • 상품번호 (product_num) — NUMBER(5) — Primary key — NOT NULL
  • 상품명 (product_name) — VARCHAR2(15)
  • 가격 (price) — NUMBER(5)
  • 제조일자 (product_date) — DATE
  • 입고일자 (receiving_date) — DATE
  • 유통기한 (expiration_date) — DATE
  • 원가? (Field)

SalesManagement (Untitled3)

  • 매출번호 (sales_num) — VARCHAR(8) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3