test
Tables (18)
accounts
- id — SERIAL
- organization_id — VARCHAR(255) — NOT NULL
- platform — VARCHAR(32) — NOT NULL
- service — VARCHAR(32) — NOT NULL
- hint — VARCHAR(32) — NOT NULL
- data — TEXT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
cdn_details
- cdn_id — INT — Primary key — NOT NULL
- hint — VARCHAR(32) — NOT NULL
- data — TEXT — NOT NULL
cdns
- id — SERIAL
- project_id — INT — NOT NULL
- platform — VARCHAR(32) — NOT NULL
- service — VARCHAR(32) — NOT NULL
- cname — VARCHAR(255) — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
dns_details
- dns_id — INT — Primary key — NOT NULL
- hint — VARCHAR(32) — NOT NULL
- data — TEXT — NOT NULL
dnses
- id — SERIAL
- project_id — INT — NOT NULL
- platform — VARCHAR(32) — NOT NULL
- service — VARCHAR(32) — NOT NULL
- cname — VARCHAR(255) — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
notification_events
- id — SERIAL
- notification_id — INT — NOT NULL
- case — VARCHAR(64) — NOT NULL
notification_subscribers
- id — SERIAL
- notification_id — INT — NOT NULL
- subscribeType — VARCHAR(32) — NOT NULL
- target — VARCHAR(2048) — NOT NULL
notifications
- id — SERIAL
- project_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
organizations
- id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
project_details
- project_id — INT — Primary key — NOT NULL
- description — TEXT
projects
- id — SERIAL
- organization_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
routing_policies
- id — SERIAL
- project_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
routing_triggers
- id — SERIAL
- project_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
scheduled_routing_triggers
- routing_trigger_id — INT — NOT NULL
- priority — INT — NOT NULL
- startDatetime — TIMESTAMP — NOT NULL
- endDatetime — TIMESTAMP
storage_details
- storage_id — INT — Primary key — NOT NULL
- hint — VARCHAR(32) — NOT NULL
- data — TEXT — NOT NULL
storages
- id — SERIAL
- project_id — INT — NOT NULL
- platform — VARCHAR(32) — NOT NULL
- service — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- creator_id — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updater_id — VARCHAR(255)
- version — INT — NOT NULL
- is_enabled — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
traffic_routes
- routing_policy_id — INT — Primary key — NOT NULL
- cdn_id — INT — Primary key — NOT NULL
- platform — VARCHAR(32) — NOT NULL
- service — VARCHAR(32) — NOT NULL
- hint — VARCHAR(32) — NOT NULL
- data — TEXT — NOT NULL
users
- id — VARCHAR(255) — Primary key — NOT NULL
- organization_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- is_deleted — BIT(1) — NOT NULL