pamajon

Tables (5)

BRAND (회사 분류)

  • Key (brand_code) — NUMBER — Primary key — NOT NULL
  • Field (brand_name) — VARCHAR2(255)

CATEGORY (상품 분류)

  • Key (category_code) — NUMBER — Primary key — NOT NULL
  • Field (category_name) — VARCHAR2(255)

PRODUCT (상품)

  • Key (product_id) — NUMBER — Primary key — NOT NULL — SEQUENCE
  • Key (category_code) — NUMBER — Foreign key → CATEGORY.Key — NOT NULL
  • Key (brand_code) — NUMBER — Foreign key → BRAND.Key — NOT NULL
  • Field (price) — NUMBER
  • Field (product_name) — VARCHAR2(300)

STOCK (재고)

  • Key (store_id) — NUMBER — Foreign key → STORE.Key — NOT NULL — SEQUENCE
  • Key (product_id) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL — SEQUENCE
  • Key (category_code2) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL
  • Key (brand_code2) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL
  • Field (quantity) — NUMBER

STORE (점포)

  • Key (store_id) — NUMBER — Primary key — NOT NULL — SEQUENCE
  • Field (store_name) — VARCHAR2(255)
  • Field2 (phone) — VARCHAR2(25)
  • Field3 (address) — VARCHAR2(300)