test
Tables (23)
COMMERCIAL_PRODUCT
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
- ORIGINAL_PRICE — INT — NOT NULL
- CREATOR — VARCHAR(16) — NOT NULL
- CREATE_TS — TIMESTAMP — NOT NULL
- MODIFIER — VARCHAR(16)
- MODIFY_TS — TIMESTAMP
COMMERCIAL_PRODUCT_CATEGORY
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
- DESCRIPTION — VARCHAR(255)
- CREATOR — VARCHAR(16) — NOT NULL
- CREATE_TS — TIMESTAMP — NOT NULL
- MODIFIER — VARCHAR(16)
- MODIFIER_TS — TIMESTAMP
COMMERCIAL_PRODUCT_CATEGORY_HIERARCHY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PARENT_ID — VARCHAR(16) — NOT NULL
- CHILD_ID — VARCHAR(16) — NOT NULL
COMMERCIAL_PRODUCT_CATEGORY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_ID — VARCHAR(16) — NOT NULL
- CP_CAT_ID — VARCHAR(16) — NOT NULL
COMMERCIAL_PRODUCT_DETAIL
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_DETAIL_ID — VARCHAR(16) — NOT NULL
- KEY — VARCHAR(255) — NOT NULL
- VALUE — VARCHAR(255) — NOT NULL
- TYPE — VARCHAR(16) — NOT NULL
- DESCRIPTION — VARCHAR(255)
COMMERCIAL_PRODUCT_DETAIL_GROUP
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_ID — VARCHAR(16) — NOT NULL
- PARENT_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
COMMERCIAL_PRODUCT_HIERARCHY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PRAENT_ID — VARCHAR(16) — NOT NULL
- CHILD_ID — VARCHAR(16) — NOT NULL
COMMERCIAL_PRODUCT_OPTION
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_OPT_GROUP_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
COMMERCIAL_PRODUCT_OPTION_COMBINATION
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255)
- QUANTITY — INT — NOT NULL — 판매가능수량
COMMERCIAL_PRODUCT_OPTION_COMBINATION_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_OPT_ID — VARCHAR(16) — NOT NULL
- PD_OPT_COMB_ID — VARCHAR(16) — NOT NULL
COMMERCIAL_PRODUCT_OPTION_GROUP
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255)
- PD_NAME — VARCHAR(255)
- PD_ID — VARCHAR(16) — 참조용
PRICE_POLICY
- ID — VARCHAR(16) — Primary key — NOT NULL
- CP_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
PRODUCT
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
- IS_TEMPORARY — CHAR(1) — NOT NULL — boolean(T/F)
- CREATOR — VARCHAR(16) — NOT NULL
- CREATE_TS — TIMESTAMP — NOT NULL
- MODIFIER — VARCHAR(16)
- MODIFY_TS — TIMESTAMP
PRODUCT_CATEGORY
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
- DESCRIPTION — VARCHAR(255)
- CREATOR — VARCHAR(16) — NOT NULL
- CREATE_TS — TIMESTAMP — NOT NULL
- MODIFIER — VARCHAR(16)
- MODIFY_TS — TIMESTAMP
PRODUCT_CATEGORY_HIERARCHY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PARENT_ID — VARCHAR(16) — NOT NULL
- CHILD_ID — VARCHAR(16) — NOT NULL
PRODUCT_CATEGORY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_ID — VARCHAR(16) — NOT NULL
- PD_CAT_ID — VARCHAR(16) — NOT NULL
PRODUCT_DETAIL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_DETAIL_GROUP_ID — VARCHAR(16) — NOT NULL
- KEY — VARCHAR(255) — NOT NULL
- VALUE — VARCHAR(255) — NOT NULL
- TYPE — VARCHAR(16) — NOT NULL
- DESCRIPTION — VARCHAR(255)
PRODUCT_DETAIL_GROUP
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_ID — VARCHAR(16)
- PARENT_ID — VARCHAR(16)
- NAME — VARCHAR(255) — NOT NULL
PRODUCT_HIERARCHY_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PARENT_ID — VARCHAR(16) — NOT NULL
- CHILD_ID — VARCHAR(16) — NOT NULL
PRODUCT_OPTION
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_OPT_GROUP_ID — VARCHAR(16) — NOT NULL
- NAME — VARCHAR(255)
PRODUCT_OPTION_COMBINATION
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255)
- QUANTITY — INT — NOT NULL — 재고수량
PRODUCT_OPTION_COMBINATION_REL
- ID — VARCHAR(16) — Primary key — NOT NULL
- PD_OPT_COMB_ID — VARCHAR(16) — NOT NULL
- PD_OPT_ID — VARCHAR(16) — NOT NULL
PRODUCT_OPTION_GROUP
- ID — VARCHAR(16) — Primary key — NOT NULL
- NAME — VARCHAR(255) — NULL → Default
- PD_ID — VARCHAR(16) — NOT NULL