Portal
Tables (13)
account_slave
- slave_id (Key) — Primary key — NOT NULL
app_api_match
- app_api_match_id — INT(10) — Primary key — NOT NULL — app_api_match ID
- portal_api_id — INT(10) — Foreign key → portal_api.portal_api_id — NOT NULL — portal_api ID
- portal_app_id — INT(10) — Foreign key → portal_app.portal_app_id — NOT NULL — portal_app ID
- register_date (Field3) — DATETIME — NOT NULL — 등록일자
bizunit
- bizunit_sno — Primary key — NOT NULL
bizunit_api_match
- bizunit_api_match_id — INT(10) — Primary key — NOT NULL — bizunit_api_match ID
- portal_api_id — INT(10) — Foreign key → portal_api.portal_api_id — NOT NULL — portal_api ID
- bizunit_sno (bizunit_sno2) — INT(10) — Foreign key → bizunit.bizunit_sno — NOT NULL — Biz Unit SNO
- register_date (Field3) — DATETIME — NOT NULL — 등록일자
portal_account
- portal_account_id — INT(10) — Primary key — NOT NULL — Portal_account ID
- portal_account_name — VARCHAR(50) — NOT NULL — Portal_account 이름
- portal_account_email — VARCHAR(64) — NOT NULL — Portal_account 이메일
- portal_account_passphrase — BINARY(32) — NOT NULL — Portal_account 로그인 비밀번호
- portal_account_status_code — TINYINT(3) — NOT NULL — Portal_account 상태 코드 (0=inactive, 1=active, 2=deactivated)
- portal_list_id — INT(10) — Foreign key → portal_list.portal_list_id — NOT NULL — Portal_List ID
- register_date — DATETIME — NOT NULL — 등록일자
- modify_date — DATETIME — 수정일자
- login_date — DATETIME — 로그인 일자
portal_api
- portal_api_id — INT(10) — Primary key — NOT NULL — portal_api ID
- portal_api_name — VARCHAR(50) — NOT NULL — portal_api 이름
- portal_api_display_name — VARCHAR(100) — NOT NULL — portal_api Display 이름
- portal_api_description — VARCHAR(1000) — NOT NULL — portal_api 설명
- portal_list_id — INT(10) — Foreign key → portal_list.portal_list_id — NOT NULL — Portal_List ID
- register_date (Field4) — DATETIME — NOT NULL — 등록일자
- modify_date (Field5) — DATETIME — 수정일자
portal_app
- portal_app_id — INT(10) — Primary key — NOT NULL — portal_app ID
- portal_app_name — VARCHAR(50) — NOT NULL — portal_app 이름
- portal_app_description — VARCHAR(1000) — NOT NULL — portal_app 설명
- portal_account_id — INT(10) — Foreign key → portal_account.portal_account_id — NOT NULL — Portal_account ID
- register_date (Field) — DATETIME — NOT NULL — 등록일자
- modify_date (Field2) — DATETIME — 수정일자
portal_credential
- portal_credential_id — INT(10) — Primary key — NOT NULL — portal_credential ID
- portal_app_id — INT(10) — Foreign key → portal_app.portal_app_id — NOT NULL — portal_app ID
- portal_credential_type (Field2) — TINYINT(3) — NOT NULL — credential 타입(10 : Oauth / 20 : Simplekey / 30 : SecureProtocol)
- key_value (Field3) — JSON — NOT NULL — Key 값
- register_date (Field) — DATETIME — NOT NULL — 등록일자
portal_list
- portal_list_id — INT(10) — Primary key — NOT NULL — Portal_List ID
- portal_list_name — VARCHAR(50) — NOT NULL — Portal_List 이름
- portal_list_description — VARCHAR(1000) — NOT NULL — Portal_List 설명
- portal_url — VARCHAR(128) — NOT NULL — portal URL
- slave_id (Key) — SMALLINT(5) — Foreign key → account_slave.slave_id — NOT NULL — User ID
- register_date — DATETIME — NOT NULL — 등록일자
- modify_date — DATETIME — 수정일자