111
Tables (13)
bn_mng
- bn_mng_id — text — Primary key — NOT NULL
- reg_tmstmp — timestamp
- reg_id — text
- bn_type_id — text
- is_reserved — boolean — NOT NULL
- is_fixed — boolean — NOT NULL
- column_prefix — text
- 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 — text
change_log
- id — serial — Primary key — NOT NULL
- table_name — text — NOT NULL
- change_time — timestamp — NOT NULL
- changes — jsonb — NOT NULL
crt_mng
- crt_mng_id — text — Primary key — NOT NULL
- reg_tmstmp — timestamp — NOT NULL
- loaded_info_json — jsonb
- reg_id — bigint
- udt_id — bigint
- udt_tmstmp — timestamp
- crt_status — text
- usr_mng_id — bigint
- is_loaded — boolean
detail_info_mng
- detail_info_mng_id — text — Primary key — NOT NULL
- keyword — text
- appearance — text
- OTCETC — text
- confirm_date — date
- standard_code — text
- ingredient — jsonb
- additives — jsonb
- efficacy — text
- dosage — text
- caution — text
- preservation — text
- shelf_life_month — integer
- created_at — timestamp
local_mng
- local_mng_id — serial — Primary key — NOT NULL
- stck_mng_id — bigint
- qty — bigint
- supplier — text
- phrm_mng_id — integer
- phrm_nm — text
- prd_nm — text
- exp_dt — date
- redrawed — boolean
- rcvd_date — date
- ord_date — date
mnfc_mng
- mnfc_mng_id — text — Primary key — NOT NULL
- mnfc_nm — text — NOT NULL
- vnd_bs_mdl — text
- is_deleted — boolean
- reg_tmstmp — timestamp
- reg_id — text
- udt_tmstmp — timestamp
- udt_id — text
phrm_mng
- phrm_mng_id — bigint — Primary key — NOT NULL
- phrm_nm — text — NOT NULL
- phrm_address — text
- phrm_tel — text
- is_deleted — boolean
- reg_tmstmp — timestamp — NOT NULL
- reg_id — text
- udt_tmstmp — timestamp
- udt_id — text
phrm_ord_cart_mng
- phrm_ord_cart_mng_id — serial — Primary key — NOT NULL
- phrm_mng_id — bigint — NOT NULL
- prd_mng_id — text — NOT NULL
- qty — integer — NOT NULL
phrm_ord_mng
- phrm_ord_mng_id — bigint — Primary key — NOT NULL
- ord_tmstmp — timestamp
- prd_mng_id — text
- qty — integer
- is_ord_rcv — boolean
- phrm_ord_status — text
- is_ord_cmp — boolean
- upd_tmstmp — timestamp
- dlvry_tmstmp — timestamp
- phrm_mng_id — bigint — NOT NULL
- status — text
prd_mng
- prd_mng_id — text — Primary key — NOT NULL
- mnfc_mng_id — text
- prd_nm — text
- prd_desc — text
- reg_tmstmp — timestamp
- reg_id — text
- udt_tmstmp — timestamp
- udt_id — text
- gvmnt_cd — text
- detail_info_mng_id — text
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 — text
- parent_stck_mng_id — bigint — NOT NULL
- crrnt_tsk_id — text
- lot_serial — text
- qty — bigint — NOT NULL
- stck_status — text
- crt_mng_id — bigint
- shelf_life — bigint
- device_id — text
- batch — text
- lst_wt_mng_id — text
- 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
- 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 — text — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- device_id — text
- src_bn_mng_id — text
- dst_bn_mng_id — text
- wt_status — text
- updated_at — timestamp — NOT NULL
- wt_type — text
- wrhs_order_id — text
- prd_mng_id — text
- prd_nm — text
- qty — bigint
- unit — text
- batch — text
- serial — text
- exp_dt — date
- crrnt_job — text
- nxt_job — text
- stck_mng_id — bigint