Portal

Tables (13)

account_slave

  • slave_id (Key) — Primary key — NOT NULL

app

    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 — 등록일자

    object

      operator

        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 — 수정일자

        revision