2

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