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