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