밴츠_Parts
테이블 (8)
Copy Of (car_model)
- Key (CM_IDX) — int(11) — 기본 키 — NOT NULL
- Field (MODEL_NAME) — varchar(30)
- Field (MODEL_ORG_NAME) — varchar(200)
- Field (VIEW_YN) — enum("Y","N")
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
Copy Of 2 (car_model_detail)
- Key (CMD_IDX) — int(11) — 기본 키 — NOT NULL
- Field (CMD_CODE) — int(11)
- Key (CM_IDX) — int(11) — 외래 키 → Copy Of .Key — NOT NULL
- Key (CB_IDX) — int(11) — 외래 키 → Untitled.Key — NOT NULL
- Field (CMD_NAME) — varchar(30)
- Field (VIEW_YN) — enum("Y","N")
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
Copy Of Copy Of (car_parts_price)
- Key (CPP_IDX) — int(11) — 기본 키 — NOT NULL
- Key (MP_IDX) — int(11) — 외래 키 → Copy Of Copy Of Copy Of .Key — NOT NULL
- Field (CMD_CODE) — int(11)
- Field (APPLY_DATE) — date
- Field (RETAIL_PRICE)
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
Copy Of Copy Of Copy Of (mbk_part)
- Key (MP_IDX) — int(11) — 기본 키 — NOT NULL
- Key (MPG_IDX) — int(11) — 외래 키 → Copy Of Copy Of Copy Of Copy Of .Key — NOT NULL
- Field (CMD_CODE) — int(11)
- Field (PART_CODE) — varchar(50)
- Field (PART_NAME) — varchar(200)
- Field (PART_NAME_KR) — varchar(200)
- Field (APPLY_DATE) — date
- Field (RETAIL_PRICE)
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
- Field2 (PART_TYPE) — enum("C,"T")
Copy Of Copy Of Copy Of 2 (car_part_price_log)
- Key (CPP_IDX) — int(11) — 기본 키 — NOT NULL
- Key (MP_IDX) — int(11) — 외래 키 → Copy Of Copy Of Copy Of .Key — NOT NULL
- Field (CMD_CODE) — int(11)
- Field (APPLY_DATE) — date
- Field (RETAIL_PRICE)
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
Copy Of Copy Of Copy Of Copy Of (mbk_part_group)
- Key (MPG_IDX) — int(11) — 기본 키 — NOT NULL
- Field (PGROUP_CODE) — varchar(2)
- Field (PGROUP_NAME) — varchar(100)
- Field (PGROUP_NAME_ENG) — varchar(100)
- Field (APPLY_DATE) — date
- Field (RETAIL_PRICE)
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE) — datetime
Untitled (car_brand)
- Key (CB_IDX) — int(11) — 기본 키 — NOT NULL
- Field (BRAND_NAME) — varchar(30)
- Field (REG_ID) — varchar(200)
- Field (REG_DATE) — datetime
- Field (MOD_ID) — varchar(200)
- Field (MOD_DATE) — datetime
- Field (DEL_YN) — enum("Y","N")
- Field (DEL_IP) — varchar(20)
- Field (DEL_ID) — varchar(200)
- Field (DEL_DATE)
s (action_log)
- Key — int(10) — 기본 키 — NOT NULL
- Field2 (User_ID) — varchar(32)
- Field (ACTION_DATE) — DATE
- Field (ACTION_FILE) — varchar(32)
- Field2 (IP_ADDR) — varchar(15)
- Field (ACTION_DATA) — text
- Field