cosmax
Tables (23)
BRAND
- BRAND_KEY — NUMBER — Primary key
- BRAND_NAME — VARCHAR2(4000 BYTE)
- BRAND_FEATURE — VARCHAR2(4000 BYTE)
- BRAND_EFFECT — VARCHAR2(4000 BYTE)
- BRAND_CERTIFICATION — VARCHAR2(4000 BYTE)
- BRAND_IMAGE — VARCHAR2(4000 BYTE)
BRAND_LEVEL
- BRAND_LEVEL_KEY — NUMBER — Primary key
- BRAND_KEY — NUMBER — Foreign key → BRAND.BRAND_KEY
- LEVELTHREE_KEY — NUMBER — Foreign key → FORMULAR_LEVELTHREE.LEVELTHREE_KEY
CONCEPT_INGREDIENT
- INGREDIENT_KEY — NUMBER — Primary key
- CATEGORY_KEY (INGREDIENT_CATEGORY_KEY) — NUMBER — Foreign key → INGREDIENT_CATEGORY.CATEGORY_KEY
- FORMULATION_KEY (INGREDIENT_FORMULATION) — NUMBER — Foreign key → FORMULATION.FORMULATION_KEY
- INGREDIENT_NAME — VARCHAR2(4000 BYTE)
- INGREDIENT_INCI — VARCHAR2(4000 BYTE)
- INGREDIENT_FEATURE — VARCHAR2(4000 BYTE)
- INGREDIENT_EWG — VARCHAR2(4000 BYTE)
- INGREDIENT_DESCRIPTION — VARCHAR2(4000 BYTE)
CONSULTATION
- CONSULTATION_KEY — NUMBER — Primary key
- RESERVATION_KEY — NUMBER — Foreign key → RESERVATION.RESERVATION_KEY
- USER_KEY — NUMBER
- MGR_ID — VARCHAR2(400 BYTE)
- CONSULTATION_CATEGORY — VARCHAR2(20 BYTE)
- CONSULTATION_ITEM — VARCHAR2(20 BYTE)
- CONSULTATION_CREATE_DATE — VARCHAR2(4000 BYTE)
- CONSULTATION_CONTENT — VARCHAR2(4000 BYTE)
- CONSULTATION_RESPONSE_DATE — VARCHAR2(20 BYTE)
- CONSULTATION_STATE — NUMBER
- CONSULTATION_RESULT — VARCHAR2(4000 BYTE)
- CONSULTATION_REJECTION — VARCHAR2(4000 BYTE)
DEVELOPMENT
- DEVELOPMENT_KEY — NUMBER — Primary key
- FORMULATION_KEY — NUMBER — Foreign key → FORMULATION.FORMULATION_KEY
- USER_KEY — NUMBER — Foreign key → USERS.USER_KEY — NOT NULL
- USERLEVEL_KEY — NUMBER — Foreign key → USERS.USERLEVEL_KEY
- CONSULTATION_KEY — NUMBER — Foreign key → CONSULTATION.CONSULTATION_KEY
- DESIGN,STRATEGY,MARKTING (MGR_ID) — VARCHAR2(20 BYTE) — Foreign key → MANAGER.MGR_ID
- DISTRIBUTION_KEY (DISTRIBUTION_KEY2) — Foreign key → USERS.DISTRIBUTION_KEY — NOT NULL
- DEVELOPMENT_TYPE — VARCHAR2(20 BYTE)
- DEVELOPMENT_CONTENT — VARCHAR2(20 BYTE)
- DEVELOPMENT_STATE — NUMBER
- DEVELOPMENT_RESEARCHER — NUMBER
- DEVELOPMENT_LAB — VARCHAR2(20 BYTE)
- DEVELOPMENT_SHIPPING — VARCHAR2(20 BYTE)
- DEVELOPMENT_FEEDBACK — VARCHAR2(20 BYTE)
- DEVELOPMENT_APPROVAL_DATE — VARCHAR2(20 BYTE)
- DEVELOPMENT_DATE — VARCHAR2(20 BYTE)
- DEVELOPMENT_DESIGN_MGR — VARCHAR2(400 BYTE)
- DEVELOPMENT_STRATEGY_MGR — VARCHAR2(400 BYTE)
- DEVELOPMENT_MARKETING_MGR — VARCHAR2(400 BYTE)
- DEVELOPMENT_DESIGN_NOTE — VARCHAR2(4000 BYTE)
- DEVELOPMENT_STRATEGY_NOTE — VARCHAR2(4000 BYTE)
DEV_MGR
- DEV_MGR_KEY — NUMBER — Primary key
- DEV_DESIGN_MGR — VARCHAR2(20 BYTE)
- DEV_DESIGN_NOTE — VARCHAR2(20 BYTE)
- DEV_STRATAGE_MGR — VARCHAR2(20 BYTE)
- DEV_STRATGE_NOTE — VARCHAR2(20 BYTE)
- DEV_MARKETING_MGR — VARCHAR2(20 BYTE)
- DEVELOPMENT_KEY — NUMBER
DISTRIBUTIONS
- DISTRIBUTION_KEY — Primary key — NOT NULL
- SPECIALITY_STORE — CHAR(1 BYTE)
- GENERAL_STORE — CHAR(1 BYTE)
- ONLINE_STORE — CHAR(1 BYTE)
- HOMESHOPING_STORE — CHAR(1 BYTE)
- DOOR_SALES — CHAR(1 BYTE)
- ETC — VARCHAR2(20 BYTE)
- ONLINE_RATE — NUMBER
EMBLEM
- EMBLEM_KEY — NUMBER — Primary key
- CATEGORY_KEY (EMBLEM_CATEGORY) — NUMBER — Foreign key → EMBLEM_CATEGORY.CATEGORY_KEY
- EMBLEM_ENG_DESCRIPTION — VARCHAR2(4000 BYTE)
- EMBLEM_ENG_NAME — VARCHAR2(400 BYTE)
- EMBLEM_KOR_NAME — VARCHAR2(400 BYTE)
- EMBLEM_IMAGE — VARCHAR2(400 BYTE)
- EMBLEM_CERTIFICATION — VARCHAR2(400 BYTE)
- EMBLEM_KOR_DESCRIPTION — VARCHAR2(4000 BYTE)
EMBLEM_CATEGORY
- CATEGORY_KEY — NUMBER — Primary key
- CATEGORY_NAME — VARCHAR2(4000 BYTE)
FEEDBACK
- FEEDBACK_KEY — NUMBER — Primary key
- DEVELOPMENT_KEY — NUMBER — Foreign key → DEVELOPMENT.DEVELOPMENT_KEY
- USERLEVEL_KEY — NUMBER — Foreign key → DEVELOPMENT.USERLEVEL_KEY
- CONSULTATION_KEY (CONSULTATION_KEY2) — NUMBER — Foreign key → DEVELOPMENT.CONSULTATION_KEY
- MGR_ID — VARCHAR2(20 BYTE) — Foreign key → DEVELOPMENT.DESIGN,STRATEGY,MARKTING
- DISTRIBUTION_KEY (DISTRIBUTION_KEY2) — Foreign key → DEVELOPMENT.DISTRIBUTION_KEY — NOT NULL
- FEEDBACK_DATE — NVARCHAR2(20)
- FEEDBACK_CONTENT — VARCHAR2(4000 BYTE)
- FEEDBACK_GUIDE — VARCHAR2(4000 BYTE)
- FEEDBACK_MARKETER — VARCHAR2(20 BYTE)
- FEEDBACK_MGR — VARCHAR2(20 BYTE)
FORMULAR_LEVELONE
- LEVELONE_KEY — NUMBER — Primary key
- LEVELONE_NAME — VARCHAR2(400 BYTE)
FORMULAR_LEVELTHREE
- LEVELTHREE_KEY — NUMBER — Primary key
- LEVELTWO_KEY — NUMBER — Foreign key → FORMULAR_LEVELTWO.LEVELTWO_KEY
- LEVELTHREE_NAME — VARCHAR2(400 BYTE)
FORMULAR_LEVELTWO
- LEVELTWO_KEY — NUMBER — Primary key
- LEVELONE_KEY — NUMBER — Foreign key → FORMULAR_LEVELONE.LEVELONE_KEY
- LEVELTWO_NAME — VARCHAR2(400 BYTE)
FORMULATION
- FORMULATION_KEY — NUMBER — Primary key
- LEVELTHREE_KEY — NUMBER — Foreign key → FORMULAR_LEVELTHREE.LEVELTHREE_KEY
- FORMULATION_CATEGORY — NUMBER
- FORMULATION_LAB — VARCHAR2(4000 BYTE)
- FORMULATION_RECOMMEND — VARCHAR2(4000 BYTE)
- FORMULATION_USE_SENSE — VARCHAR2(4000 BYTE)
- FORMULATION_STRENGTH — VARCHAR2(4000 BYTE)
- FORMULATION_DESCRIPTION — VARCHAR2(4000 BYTE)
- FORMULATION_NAME — VARCHAR2(4000 BYTE)
- FORMULATION_ACTIVE — CHAR(1 BYTE)
- FORMULATION_HASHTAG — VARCHAR2(4000 BYTE)
- FORMULATION_IMAGE — VARCHAR2(20 BYTE)
FORMULATION_EMBLEM_RELATION
- RELATION_KEY — NUMBER — Primary key
- FORMULATION_KEY — NUMBER — Foreign key → FORMULATION.FORMULATION_KEY
- EMBLEM_KEY — NUMBER — Foreign key → EMBLEM.EMBLEM_KEY
INGREDIENT_CATEGORY
- CATEGORY_KEY — NUMBER — Primary key
- CATEGORY_NAME — VARCHAR2(4000 BYTE)
LEVELUP
- LEVELUP_KEY — NUMBER — Primary key
- USER_KEY — NUMBER — Foreign key → USERS.USER_KEY — NOT NULL
- USERLEVEL_KEY — NUMBER — Foreign key → USERS.USERLEVEL_KEY
- DISTRIBUTION_KEY (DISTRIBUTION_KEY2) — Foreign key → USERS.DISTRIBUTION_KEY — NOT NULL
- LEVELUP_CONTENT — VARCHAR2(4000 BYTE)
- LEVELUP_MOQ — NUMBER
- LEVELUP_REJECT — VARCHAR2(4000 BYTE)
- MGR_ID — VARCHAR2(20 BYTE)
- LEVELUP_REQUEST_DATE — VARCHAR2(20 BYTE)
- LEVELUP_RESPONSE_DATE — VARCHAR2(20 BYTE)
- LEVELUP_STATE — VARCHAR2(20 BYTE)
MANAGER
- MGR_ID — VARCHAR2(20 BYTE) — Primary key
- MGR_PW — VARCHAR2(100 BYTE)
- MGR_EMAIL — VARCHAR2(1000 BYTE)
- MGR_PHONE — VARCHAR2(1000 BYTE)
- MGR_NAME — VARCHAR2(1000 BYTE)
MATERIALS
- MATERIALS_KEY — NUMBER — Primary key
- LEVELTHREE_KEY — NUMBER — Foreign key → FORMULAR_LEVELTHREE.LEVELTHREE_KEY
- MATERIALS_NAME — VARCHAR2(4000 BYTE)
- MATERIALS_FEATURE — VARCHAR2(4000 BYTE)
- MATERIALS_TYPE — VARCHAR2(4000 BYTE)
- MATERIALS_PURPOSE — VARCHAR2(4000 BYTE)
- MATERIALS_CAPACITY — NUMBER
- MATERIALS_MOQ — NUMBER
- MATERIALS_HISTORY — VARCHAR2(4000 BYTE)
- MATERIALS_CATEGORY — NUMBER
- MATERIALS_IMAGE — VARCHAR2(4000 BYTE)
MGR_PROFILE
- PROFILE_KEY — NUMBER — Primary key
- MGR_ID — VARCHAR2(20 BYTE) — Foreign key → MANAGER.MGR_ID
- PART — VARCHAR2(4000 BYTE)
- ITEM — VARCHAR2(4000 BYTE)
RESERVATION
- RESERVATION_KEY — NUMBER — Primary key
- RESERVATION_DATE — VARCHAR2(20 BYTE)
- RESERVATION_TIME — VARCHAR2(20 BYTE)
- RESERVATION_COMMENT — VARCHAR2(40 BYTE)
- MGR_ID — VARCHAR2(20 BYTE)
- CONSULTATION_KEY — NUMBER
- USER_KEY — NUMBER
- RESERVATION_STATE — CHAR(1 BYTE)
- RESERVATION_TYPE — VARCHAR2(20 BYTE)
USERLEVEL
- USERLEVEL_KEY — NUMBER — Primary key
- USERLEVEL_NAME — VARCHAR2(20 BYTE)
USERS
- USER_KEY — NUMBER — Primary key — NOT NULL
- USERLEVEL_KEY (USER_LEVEL) — NUMBER — Foreign key → USERLEVEL.USERLEVEL_KEY
- DISTRIBUTION_KEY (DISTRIBUTION_KEY2) — Foreign key → DISTRIBUTIONS.DISTRIBUTION_KEY — NOT NULL
- USER_EMAIL — VARCHAR2(20 BYTE)
- USER_PW — VARCHAR2(4000 BYTE)
- USER_EXPERIENCE — NUMBER
- USER_CORP_CEO — VARCHAR2(20 BYTE)
- USER_CORP_REGION — VARCHAR2(20 BYTE)
- USER_DESIRED_COUNT — NUMBER
- USER_EXPECT_COUNT — NUMBER
- USER_CORP_MGR — VARCHAR2(20 BYTE)
- USER_CONTACT — VARCHAR2(20 BYTE)
- USER_CORP_STATE — VARCHAR2(20 BYTE)
- USER_CREATE_DATE — VARCHAR2(20 BYTE)
- USER_SAP_CODE — VARCHAR2(20 BYTE)
- USER_EBIZ_ID — VARCHAR2(20 BYTE)
- USER_MARKETING_MGR — VARCHAR2(20 BYTE)
- USER_RESEARCH_MGR — VARCHAR2(20 BYTE)
- USER_STRATGE_MGR — VARCHAR2(20 BYTE)
- USER_DESIGN_MGR — VARCHAR2(20 BYTE)
- USER_COMMENT — VARCHAR2(4000 BYTE)
- USER_CORP_SALES — VARCHAR2(20 BYTE)
- USER_CORP_HEADCOUNT — VARCHAR2(20 BYTE)
- USER_CORP_NAME — VARCHAR2(20 BYTE)
- USER_CORP_NUM — VARCHAR2(20 BYTE)