Cloud Resource ERD

Tables (11)

account (리소스 계정)

  • account_id (Key) — INT(11) — Primary key — NOT NULL
  • platform_type (Field2) — VARCHAR(10)
  • account_identifier_id (Field5) — VARCHAR(50)
  • account_name (Field1) — VARCHAR(50)
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

cloud_resource_extend (클라우드 리소스(cluster 구분 이전))

  • cloud_resorce_extend_id (Field5) — INT(11) — Primary key
  • account_id (Key) — INT(11) — NOT NULL — ID|고유식별자|
  • service_name (Field4) — VARCHAR(30)
  • resource_contents (Field1) — JSON
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

resource (클라우드 리소스)

  • resource_id (PK) — INT(11) — Primary key — NOT NULL
  • account_id (Key) — INT(11) — Foreign key → account.account_id — NOT NULL
  • service_name (Field2) — VARCHAR(30)
  • resource_contents (Field5) — JSON
  • created_at (Field6) — DATETIME
  • updated_at (Field7) — DATETIME

resource_com_code (Untitled2)

  • com_code_id (Key) — INT(11) — Primary key — NOT NULL
  • group_code_id (Key2) — VARCHAR(50) — Foreign key → resource_com_group_code.group_code_id — NOT NULL
  • resource_type_code (Field2) — INT(5)
  • code_contents (Field3) — VARCHAR(100)
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME
  • Field

resource_com_group_code (Untitled)

  • group_code_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • code_contents (Field) — VARCHAR(100)
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

resource_ec2_os_user (EC2 계정 정보 테이블)

  • user_id (PK) — INT(11) — Primary key — NOT NULL
  • resource_id (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • account_name (Field2) — VARCHAR(50)
  • ec2_id (Field) — VARCHAR(45)
  • status (Field6) — tinyint(4)
  • user_name (Field3) — VARCHAR(20)
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

resource_rds_db (클라우드 리소스 중 RDS)

  • resource_db_id (PK) — INT(11) — Primary key — NOT NULL
  • resource_id [UK] (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • db_name [UK] (Field) — VARCHAR(50)
  • db_size (Field2) — DECIMAL(5,2)
  • character_set_name (Field3) — VARCHAR(50)
  • collation_name (Field4) — VARCHAR(50)
  • updated_at (Field12) — DATETIME
  • created_at (Field11) — DATETIME

resource_rds_db_table (schema 내 테이블)

  • table_id (PK) — INT(11) — Primary key — NOT NULL
  • resource_id[UK] (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • db_name [UK] (Field10) — VARCHAR(50)
  • table_name[UK] (Field3) — VARCHAR(50)
  • table_size (Field) — DECIMAL(5,2)
  • auto_incement_size (Field2) — BIGINT(30)
  • partition_type (Field7) — VARCHAR(30)
  • table_rows (Field6) — BIGINT(30)
  • table_collation (Field8) — VARCHAR(30)
  • table_comment (Field9) — VARCHAR(500)
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

resource_rds_user (RDS 계정 정보 테이블)

  • user_id (PK) — INT(11) — Primary key — NOT NULL
  • resource_id (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • user_name [UK] (Field2) — VARCHAR(30)
  • host [UK] (Field) — VARCHAR(20)
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

resource_rds_user_lock (Untitled4)

  • user_lock_id (Key) — INT(11) — Primary key — NOT NULL
  • resource_id (PK) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • user_name [UK] (Field6) — VARCHAR(30)
  • host [UK] (Field8) — VARCHAR(20)
  • account_locked (Field) — VARCHAR(3)
  • authentication_string (Field7) — VARCHAR(100)
  • password_expired (Field2) — VARCHAR(3)
  • password_last_changed (Field3) — DATETIME
  • password_lifetime (Field9) — INT(5)
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

resource_rds_user_privilege (Untitled3)

  • user_privilege_id (Key) — INT(11) — Primary key — NOT NULL
  • resource_id (PK) — INT(11) — Foreign key → resource.resource_id — NOT NULL
  • user_name (Field8) — VARCHAR(30)
  • host (Field) — VARCHAR(20)
  • priv_level (Field2) — int(4)
  • access_db (Field3) — VARCHAR(30)
  • access_table (Field4) — VARCHAR(50)
  • access_priv (Field5) — VARCHAR(30)
  • created_at (Field6) — DATETIME
  • updated_at (Field7) — DATETIME