3
Tables (13)
bn_mng
- bn_mng_id — VARCHAR(255) — Primary key — NOT NULL
- reg_tmstmp — TIMESTAMP
- reg_id — VARCHAR(255)
- bn_type_id — VARCHAR(255)
- is_reserved — BOOLEAN — NOT NULL
- is_fixed — BOOLEAN — NOT NULL
- column_prefix — VARCHAR(255)
- x — BIGINT
- y — BIGINT
- stck_mng_id — BIGINT
- udt_date — DATE — NOT NULL
- fixed_start_date — DATE
- fixed_end_date — DATE
- is_loaded — BOOLEAN — NOT NULL
- bn_mng_type — VARCHAR(255)
change_log
- id — BIGINT — Primary key — NOT NULL
- table_name — VARCHAR(255) — NOT NULL
- change_time — TIMESTAMP — NOT NULL
- changes — JSON — NOT NULL
crt_mng
- crt_mng_id — VARCHAR(255) — Primary key — NOT NULL
- reg_tmstmp — TIMESTAMP — NOT NULL
- loaded_info_json — JSON
- reg_id — BIGINT
- udt_id — BIGINT
- udt_tmstmp — TIMESTAMP
- crt_status — VARCHAR(255)
- usr_mng_id — BIGINT
- is_loaded — BOOLEAN
detail_info_mng
- detail_info_mng_id — VARCHAR(255) — Primary key — NOT NULL
- keyword — VARCHAR(255)
- appearance — VARCHAR(255)
- OTCETC — VARCHAR(255)
- confirm_date — DATE
- standard_code — VARCHAR(255)
- ingredient — JSON
- additives — JSON
- efficacy — TEXT
- dosage — TEXT
- caution — TEXT
- preservation — TEXT
- shelf_life_month — INT
- created_at — TIMESTAMP
local_mng
- local_mng_id — BIGINT — Primary key — NOT NULL
- stck_mng_id — BIGINT
- qty — BIGINT
- supplier — VARCHAR(255)
- phrm_mng_id — INT
- phrm_nm — VARCHAR(255)
- prd_nm — VARCHAR(255)
- exp_dt — DATE
- redrawed — BOOLEAN
- rcvd_date — DATE
- ord_date — DATE
mnfc_mng
- mnfc_mng_id — VARCHAR(255) — Primary key — NOT NULL
- mnfc_nm — VARCHAR(255) — NOT NULL
- vnd_bs_mdl — VARCHAR(255)
- is_deleted — BOOLEAN
- reg_tmstmp — TIMESTAMP
- reg_id — VARCHAR(255)
- udt_tmstmp — TIMESTAMP
- udt_id — VARCHAR(255)
phrm_mng
- phrm_mng_id — BIGINT — Primary key — NOT NULL
- phrm_nm — VARCHAR(255) — NOT NULL
- phrm_address — VARCHAR(255)
- phrm_tel — VARCHAR(255)
- is_deleted — BOOLEAN
- reg_tmstmp — TIMESTAMP — NOT NULL
- reg_id — VARCHAR(255)
- udt_tmstmp — TIMESTAMP
- udt_id — VARCHAR(255)
phrm_ord_cart_mng
- phrm_ord_cart_mng_id — BIGINT — Primary key — NOT NULL
- phrm_mng_id — BIGINT — NOT NULL
- prd_mng_id — VARCHAR(255) — NOT NULL
- qty — INT — NOT NULL
phrm_ord_mng
- phrm_ord_mng_id — BIGINT — Primary key — NOT NULL
- ord_tmstmp — TIMESTAMP
- prd_mng_id — VARCHAR(255)
- qty — INT
- is_ord_rcv — BOOLEAN
- phrm_ord_status — VARCHAR(255)
- is_ord_cmp — BOOLEAN
- upd_tmstmp — TIMESTAMP
- dlvry_tmstmp — TIMESTAMP
- phrm_mng_id — BIGINT — NOT NULL
- status — VARCHAR(255)
prd_mng
- prd_mng_id — VARCHAR(255) — Primary key — NOT NULL
- mnfc_mng_id — VARCHAR(255)
- prd_nm — VARCHAR(255)
- prd_desc — TEXT
- reg_tmstmp — TIMESTAMP
- reg_id — VARCHAR(255)
- udt_tmstmp — TIMESTAMP
- udt_id — VARCHAR(255)
- gvmnt_cd — VARCHAR(255)
- detail_info_mng_id — VARCHAR(255)
stck_mng
- stck_mng_id — BIGINT — Primary key — NOT NULL
- exp_dt — DATE
- is_deleted — BOOLEAN
- reg_tmstmp — TIMESTAMP
- reg_id — BIGINT
- udt_tmstmp — TIMESTAMP
- udt_id — BIGINT
- prd_mng_id — VARCHAR(255)
- parent_stck_mng_id — BIGINT — NOT NULL
- crrnt_tsk_id — VARCHAR(255)
- lot_serial — VARCHAR(255)
- qty — BIGINT — NOT NULL
- stck_status — VARCHAR(255)
- crt_mng_id — BIGINT
- shelf_life — BIGINT
- device_id — VARCHAR(255)
- batch — VARCHAR(255)
- lst_wt_mng_id — VARCHAR(255)
- is_ordered — BOOLEAN — NOT NULL
usr_mng
- usr_mng_id — BIGINT — Primary key — NOT NULL
- level — SMALLINT
- reg_tmstmp — TIMESTAMP
- reg_id — BIGINT
- udt_tmstmp — TIMESTAMP
- org_nm — TEXT
- ip — TEXT
- key — TEXT
- fluid_ip — TEXT
- udt_id — BIGINT
- usr_nm — TEXT
- usr_status — TEXT — NOT NULL
- usr_nick — TEXT
- img_url — TEXT
- position — TEXT
- type — TEXT
wt_mng
- wt_mng_id — VARCHAR(255) — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- device_id — VARCHAR(255)
- src_bn_mng_id — VARCHAR(255)
- dst_bn_mng_id — VARCHAR(255)
- wt_status — VARCHAR(255)
- updated_at — TIMESTAMP — NOT NULL
- wt_type — VARCHAR(255)
- wrhs_order_id — VARCHAR(255)
- prd_mng_id — VARCHAR(255)
- prd_nm — VARCHAR(255)
- qty — BIGINT
- unit — VARCHAR(255)
- batch — VARCHAR(255)
- serial — VARCHAR(255)
- exp_dt — DATE
- crrnt_job — VARCHAR(255)
- nxt_job — VARCHAR(255)
- stck_mng_id — BIGINT