store

Tables (6)

STORE_BENEFITS (혜택테이블)

  • BENEFIT_NO (혜택번호) — NUMBER(2,0) — Primary key — NOT NULL
  • BENEFIT_NAME (혜택이름) — VARCHAR2(255)

STORE_PRODUCTS (상품)

  • PRODUCT_NO (상품번호) — NUMBER(4,0) — Primary key — NOT NULL
  • PRODUCT_CATEGORY_NO (카테고리번호) — NUMBER(4,0) — Foreign key → STORE_PRODUCT_CATEGORIES.PRODUCT_CATEGORY_NO — NOT NULL
  • PRODUCT_COMPANY_NO (Key) — NUMBER(4,0) — Foreign key → STORE_PRODUCT_COMPAINIES.PRODUCT_COMPANY_NO — NOT NULL
  • PRODUCT_STATUS_NO (Key2) — NUMBER(2,0) — Foreign key → STORE_PRODUCT_STATUS.PRODUCT_STATUS_NO — NOT NULL
  • PRODUCT_NAME (상품이름) — VARHCAR2(255) — NOT NULL
  • PRODUCT_PRICE (가격) — NUMBER(10,0) — NOT NULL
  • PRODUCT_DISCOUNT (할인가격) — NUMNER(10,0) — NOT NULL
  • PRODUCT_STOCK (재고수량) — NUMBER(4,0) — NOT NULL
  • PRODUCT_DESCRIPTION (설명) — VARCHAR2(2000) — NOT NULL
  • PRODUCT_CREATED_DATE (등록일) — DATE
  • PRODUCT_UPDATED_DATE (수정일) — DATE

STORE_PRODUCT_BENEFITS (Untitled)

  • PRODUCT_NO (상품번호) — NUMBER(4,0) — Foreign key → STORE_PRODUCTS.PRODUCT_NO — NOT NULL
  • PRODUCT_CATEGORY_NO (카테고리번호) — NUMBER(4,0) — Foreign key → STORE_PRODUCTS.PRODUCT_CATEGORY_NO — NOT NULL
  • PRODUCT_COMPANY_NO (Key3) — NUMBER(4,0) — Foreign key → STORE_PRODUCTS.PRODUCT_COMPANY_NO — NOT NULL
  • PRODUCT_STATUS_NO (Key22) — NUMBER(2,0) — Foreign key → STORE_PRODUCTS.PRODUCT_STATUS_NO — NOT NULL
  • BENEFIT_NO (혜택번호) — NUMBER(2,0) — Foreign key → STORE_BENEFITS.BENEFIT_NO — NOT NULL

STORE_PRODUCT_CATEGORIES (카테고리테이블)

  • PRODUCT_CATEGORY_NO (카테고리번호) — NUMBER(4,0) — Primary key — NOT NULL
  • PRODUCT_CATEGORY_NAME (카테고리이름) — VARCHAR2(255)

STORE_PRODUCT_COMPAINIES (상품제조사)

  • PRODUCT_COMPANY_NO (제조사번호) — NUMBER(4,0) — Primary key — NOT NULL
  • PRODUCT_COMPANY_NAME (제조사이름) — VARCHAR2(255)
  • PRODUCT_COMPANY_TEL (제조사전화번호) — VARCHAR2(20)

STORE_PRODUCT_STATUS (상품상태테이블)

  • PRODUCT_STATUS_NO (상태번호) — NUMBER(2,0) — Primary key — NOT NULL
  • PRODUCT_STATUS_NAME (상태이름) — VARCHAR2(255)