wf

Tables (3)

database_accounts

  • id — SERIAL — Primary key
  • id (id2) — SERIAL — Foreign key → instance_database_info.id
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • schema_name — VARCHAR(255)
  • privileges — TEXT
  • is_created — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(database_id, — username)

database_operations

  • id — SERIAL — Primary key
  • id (id2) — SERIAL — Foreign key → instance_database_info.id
  • operation_type — VARCHAR(50) — NOT NULL
  • operation_content — TEXT — NOT NULL
  • operation_data — JSONB
  • status — VARCHAR(50)
  • error_message — TEXT
  • is_completed — BOOLEAN
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

instance_database_info

  • id — SERIAL — Primary key
  • identifier — VARCHAR(255) — NOT NULL
  • host — VARCHAR(255)
  • port — INTEGER
  • master_user — VARCHAR(255)
  • db_name — VARCHAR(255) — NOT NULL
  • db_type — VARCHAR(20)
  • current_schema_count — INTEGER
  • max_schema_count — INTEGER
  • last_checked_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP