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