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)