015 2

Tables (6)

api_client

  • client_no — serial4 — Primary key — NOT NULL
  • grp_cd — varchar — Foreign key → api_user.grp_cd
  • client_key — varchar
  • report_url — varchar
  • create_date — timestamp
  • update_date — tiemstamp

api_user

  • cmp_id — varchar(15) — Primary key — NOT NULL
  • grp_cd — varchar — Primary key
  • cmp_pass — varchar(60)
  • cmp_nm — varchar(50)
  • vas_yn — boolean
  • create_date — timestamp
  • update_date — tiemstamp
  • representative_number — varchar(100)(
  • name_of_representative — varchar(100)
  • business_registration_number — varchar(13)

api_user_015_number_resource

  • number — varchar(11) — Foreign key → number015.number
  • grp_cd — varchar — Foreign key → api_client.grp_cd
  • mo_destination — varchar(100)
  • bill_cd — varchar(5)
  • works_mt_service — bool
  • create_date — timestamp
  • update_date — tiemstamp
  • works_mo_service — bool

key_set (RSA 키 정보)

  • key_no — serial4 — Primary key — NOT NULL
  • key_id — varchar(100)
  • key_algorithm — varchar(100)
  • key_size — varchar(100)
  • saved_type — varchar(100)
  • public_key — varchar(500)
  • private_key — text
  • creator — text
  • created_at — timestamp
  • modifier — varchar(100)
  • use_yn — varchar(100)
  • realm — varchar(100)

mbr_mo_encrypt_info

  • group_code — varchar — Foreign key → api_user_015_number_resource.grp_cd
  • enc_key — varchar(1000)
  • iv — varchar(1000)
  • charset — varchar(100)
  • algorithm — varchar(100)
  • rmk — varchar(1000)
  • create_dttm — timestamp

number015

  • number — varchar(11) — Primary key
  • resource_code — int4
  • is_gold_number — int1
  • ars_available — int4
  • available — int4
  • price — int4