Admin
Tables (7)
Authority (Role)
- id (role_id) — BIGINT — Primary key — NOT NULL
- service_master_config_id — BIGINT — Foreign key → ServiceMasterConfig.id — NOT NULL
- created_at (createdAt) — BIGINT
- authority_type (Field) — VARCHAR
ServiceConfig
- id (service_config_id) — Primary key — NOT NULL
- service_master_config_id — BIGINT — Foreign key → ServiceMasterConfig.id — NOT NULL
- app_code — VARCHAR
- client_type (type) — VARCHAR
- domain (service_domain) — VARCHAR
- host (config) — VARCHAR
- is_auto_mode (automode_yn) — CHAR(1)
- created_at — DATETIME
- updated_at — DATETIME
- config (internal_config) — TEXT
- token_expire_time — INT
- is_deleted (isDeleted) — CHAR(1)
ServiceConfigHistory
- id (service_config_history_id) — Primary key — NOT NULL
- service_config_id (service_master_config_id) — BIGINT — Foreign key → ServiceConfig.service_master_config_id — NOT NULL
- app_code — VARCHAR
- client_type (type) — VARCHAR
- domain (service_domain) — VARCHAR
- host (config) — VARCHAR
- is_auto_mode (automode_yn) — CHAR(1)
- created_at — DATETIME
- config (internal_config) — TEXT
- is_deleted (server_host) — CHAR(1)
- token_expire_time — INT
ServiceMasterConfig
- id (service_master_config_id) — BIGINT — Primary key — NOT NULL
- in_house_service — CHAR(1)
- region — VARCHAR
- env_profile — VARCHAR
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — CHAR(1)
- service_id (Field) — VARCHAR
- allow_oembed_providers (Field2) — VARCHAR
- is_used (Field3) — CHAR(1)
- google_map_channel_id (Field4) — VARCHAR
- google_place_app_key (Field5) — VARCHAR
- audio_infra_service_id (Field6) — VARCHAR
- audio_infra_partner_key (Field7) — VARCHAR
- audio_infra_partner_id (Field8) — VARCHAR
- file_upload_host (Field9) — VARCHAR
- file_upload_path (Field10) — VARCHAR
- file_upload_hmac_key (Field11) — VARCHAR
- naver_auto_complete_host (Field12) — VARCHAR
- naver_auto_complete_default_query (Field13) — VARCHAR
- mash_up_svc (Field14) — VARCHAR
- mash_up_app (Field15) — VARCHAR
- photo_uploader_host (Field16) — VARCHAR
- photo_uploader_service_name (Field17) — VARCHAR
- photo_uploader_api_key (Field18) — VARCHAR
- photo_exif_host (Field19) — VARCHAR
- video_v2_uploader_service_id (Field20) — VARCHAR
- video_v2_uploader_service_key (Field21) — VARCHAR
ServiceMasterConfigHistory
- id (service_master_config_history_id) — BIGINT — Primary key — NOT NULL
- service_master_config_id — BIGINT — Foreign key → ServiceMasterConfig.id — NOT NULL
- in_house_service — CHAR(1)
- env_profile — VARCHAR
- region — VARCHAR
- created_at — DATETIME
- service_id (Field) — VARCHAR
- allow_oembed_providers (Field2) — VARCHAR
- is_used (Field3) — VARCHAR
- audio_infra_service_id (Field4) — VARCHAR
- audio_infra_partner_key (Field5) — VARCHAR
- audio_infra_partner_id (Field6) — VARCHAR
- file_upload_host (Field7) — VARCHAR
- file_upload_path (Field8) — VARCHAR
- file_upload_hmac_key (Field9) — VARCHAR
- google_map_channel_id (Field10) — VARCHAR
- google_place_app_key (Field11) — VARCHAR
- naver_auto_complete_host (Field12) — VARCHAR
- naver_auto_complete_default_query (Field13) — VARCHAR
- mash_up_svc (Field14) — VARCHAR
- mash_up_app (Field15) — VARCHAR
- photo_uploader_host (Field16) — VARCHAR
- photo_uploader_service_name (Field17) — VARCHAR
- photo_uploader_api_key (Field18) — VARCHAR
- photo_exif_host (Field19) — VARCHAR
- video_v2_uploader_service_id (Field20) — VARCHAR
- video_v2_uploader_service_key (Field21) — VARCHAR
User (UserEntity)
- id (user_id) — VARCHAR — Primary key — NOT NULL
- name — VARCHAR
- created_at (createdAt) — DATETIME
- updated_at (updatedAt) — DATETIME
- role (type) — VARCHAR
- dept_code (Field4) — VARCHAR
- dept_name (Field5) — VARCHAR
- position (Field6) — VARCHAR
- job_dt_code (Field7) — VARCHAR
- job_dt_name (Field8) — VARCHAR
- pin_code (Field9) — VARCHAR
- is_deleted (Field13) — CHAR(1)
UserAuthority (UserRole)
- id (user_role_id) — Primary key — NOT NULL
- user_id — VARCHAR — Foreign key → User.id — NOT NULL
- authority_id (service_master_config_id) — BIGINT — Foreign key → Authority.service_master_config_id — NOT NULL
- created_at (createdAt) — DATETIME