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