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)