밴츠_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