Prosthesis

Tables (14)

factory_prostheses

  • pid — int — Primary key — NOT NULL
  • factory_prosthesis_kind_node_pid — int — Foreign key → factory_prosthesis_kind_nodes.pid — NOT NULL
  • prosthesis_pid — int — Foreign key → prostheses.pid — NOT NULL
  • factory_pid — int — NOT NULL
  • deleted — tinyint(1) — NOT NULL
  • name — varchar(200) — NOT NULL
  • nickname — varchar(200)
  • hidden — TINYINT — NOT NULL
  • preset_type — varchar(45) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — int — NOT NULL
  • modified_at — datetime — NOT NULL
  • modified_by — int — NOT NULL

factory_prosthesis_kind_nodes

  • pid — int — Primary key — NOT NULL
  • factory_pid — int — NOT NULL
  • kind_node_pid — int — Foreign key → prosthesis_kind_nodes.pid — NOT NULL
  • priority — int — NOT NULL

factory_prosthesis_prices

  • pid — int — Primary key — NOT NULL
  • factory_prosthesis_pid — int — Foreign key → factory_prostheses.pid — NOT NULL
  • currency — varchar(8) — NOT NULL
  • price — decimal(18, 4) — NOT NULL

original_prosthesis_price

  • pid — INT — Primary key — NOT NULL
  • prosthesis_pid — int — Foreign key → prosthesis.pid — NOT NULL
  • factory_pid — INT — NOT NULL — MUL(unique)
  • partner_pid — INT — NOT NULL — MUL(unique)
  • prosthesis_code — VARCHAR — MUL (index)
  • price — DECIMAL — NOT NULL
  • currency — VARCHAR — NOT NULL
  • hidden — TINYINT — NOT NULL
  • hidden_partner — TINYINT — NOT NULL
  • nickname — VARCHAR
  • created_at — DATETIME — NOT NULL — default 값 추가?
  • created_by — INT — NOT NULL
  • modified_at — DATETIME — default 값 추가?
  • modified_by — INT — NOT NULL
  • code_temp — VARCHAR — MUL (index) 맞는지 확인
  • visible

partner_prostheses (partner_prosthesis)

  • pid — INT — Primary key — NOT NULL
  • factory_prosthesis_pid — int — Foreign key → factory_prostheses.pid — NOT NULL
  • partner_pid — INT — NOT NULL
  • hidden — TINYINT — NOT NULL
  • hidden_partner — TINYINT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • nickname — VARCHAR
  • created_at — DATETIME — NOT NULL
  • created_by — INT — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • modified_by — INT — NOT NULL

partner_prosthesis_prices

  • pid — int — Primary key — NOT NULL
  • partner_prosthesis_pid — INT — Foreign key → partner_prostheses.pid — NOT NULL
  • currency — varchar(8) — NOT NULL
  • price — decimal(18, 4) — NOT NULL

prostheses

  • pid — int — Primary key — NOT NULL
  • kind_node_pid — int — Foreign key → prosthesis_kind_nodes.pid — NOT NULL
  • name — varchar(200) — NOT NULL
  • deleted — tinyint — NOT NULL
  • template — varchar(45) — NOT NULL
  • created_factory_pid — int
  • preset_type — varchar(64) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — int — NOT NULL
  • modified_at — datetime — NOT NULL
  • modified_by — int — NOT NULL

prosthesis (original_prosthesis)

  • pid — int — Primary key — NOT NULL
  • basic_code — varchar(30) — Foreign key → prosthesis_basic.pid — NOT NULL
  • category_code — varchar(30) — Foreign key → prosthesis_category.pid — NOT NULL
  • name — varchar(200)
  • price — decimal(10,0) — NOT NULL
  • parent_pid — int
  • priority — int
  • depth — int
  • category — varchar(50)
  • additional — tinyint(1) — NOT NULL
  • deleted — tinyint(1) — NOT NULL
  • code — varchar(30)
  • factory_pid — int — NOT NULL
  • nickname — varchar(200)
  • template — varchar(45)
  • created_at — datetime — NOT NULL
  • created_by — int — NOT NULL
  • modified_at — datetime — NOT NULL
  • modified_by — int — NOT NULL
  • code_temp — varchar(30)
  • price_usd — decimal(12,2) — NOT NULL

prosthesis_basic (original_prosthesis_basic)

  • pid — int — Primary key — NOT NULL
  • category_code — varchar(30) — Foreign key → prosthesis_basic_category.pid — NOT NULL
  • name — varchar(200) — NOT NULL
  • price — decimal(10, 0) — NOT NULL
  • parent_pid — int
  • priority — int
  • DEPTH — tinyint
  • category — varchar(50)
  • additional — tinyint — NOT NULL
  • deleted — tinyint — NOT NULL
  • code — varchar(30)
  • template — varchar(45)
  • prosthesis_pid_old — int
  • price_usd — decimal(12, 2) — NOT NULL
  • created_at — datetime
  • modified_at — datetime
  • is_dentrion — tinyint — NOT NULL — 외부 기공소 여부 판단

prosthesis_basic_category (original_prosthesis_basic_category)

  • pid — int — Primary key — NOT NULL
  • name — varchar(200) — NOT NULL
  • priority — int
  • deleted — tinyint(1)
  • code — varchar(30)

prosthesis_category (original_prosthesis_category)

  • pid — int — Primary key — NOT NULL
  • name — varchar(200) — NOT NULL
  • priority — int
  • deleted — tinyint(1)
  • code — varchar(30)
  • template — varchar(45)
  • nickname — varchar(200)
  • factory_pid — int — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — int — NOT NULL
  • modified_at — datetime — NOT NULL
  • modified_by — int — NOT NULL

prosthesis_kind_nodes

  • pid — int — Primary key — NOT NULL
  • depth — int — NOT NULL
  • parent_pid — int — Foreign key → prosthesis_kind_nodes.pid — NOT NULL
  • kind_pid — int — Foreign key → prosthesis_kinds.pid — NOT NULL
  • preset_type — varchar(64) — NOT NULL
  • priority — int — NOT NULL
  • terminal — tinyint — NOT NULL

prosthesis_kinds

  • pid — int — Primary key — NOT NULL
  • name — varchar(200) — NOT NULL
  • en_name — varchar(200) — NOT NULL
  • priority — int — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — int — NOT NULL
  • modified_at — datetime — NOT NULL
  • modified_by — int — NOT NULL

prosthesis_prices

  • pid — int — Primary key — NOT NULL
  • prosthesis_pid — int — Foreign key → prostheses.pid — NOT NULL
  • currency — varchar(8) — NOT NULL
  • price — decimal(18, 4) — NOT NULL