final
Tables (16)
audit_log
- id — BIGINT
- actor_user_id — BIGINT
- action — VARCHAR(50) — NOT NULL
- entity — VARCHAR(50) — NOT NULL
- entity_id — BIGINT — NOT NULL
- payload — TEXT
- created_at — DATETIME — NOT NULL
category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- parent_id — BIGINT
- created_at — TIMESTAMP
email_verification_token
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- token — CHAR(64) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- created_at — DATETIME — NOT NULL
- extra_field — VARCHAR(255)
industry
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- created_at — TIMESTAMP
password_reset_token
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- token — CHAR(64) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- requested_ip — VARCHAR(45)
- created_at — DATETIME — NOT NULL
purpose
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- created_at — TIMESTAMP
refresh_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- refresh_token — CHAR(128) — NOT NULL
- issued_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked_at — DATETIME
- client_info — VARCHAR(255)
role
- role_id — BIGINT — Primary key — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
template
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- request_content — TEXT
- status — ENUM('CREATE_REQUESTED','CREATED','APPROVE_REQUESTED','APPROVED','REJECTED','FAILED','DELETED')
- type — ENUM('LINK','MESSAGE','DOCUMENT')
- is_public — BOOLEAN
- image_url — VARCHAR(500)
- reject_reason — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- field — VARCHAR(255)
template_button
- id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- ordering — INT
- link_pc — VARCHAR(500)
- link_and — VARCHAR(500)
- link_ios — VARCHAR(500)
- created_at — TIMESTAMP
template_history
- id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — NOT NULL
- status — ENUM('CREATE_REQUESTED','CREATED','APPROVE_REQUESTED','APPROVED','REJECTED','FAILED','DELETED')
- created_at — TIMESTAMP
template_industry
- id — BIGINT — Primary key — NOT NULL
- industry_id — BIGINT — NOT NULL
- template_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
template_purpose
- id — BIGINT — Primary key — NOT NULL
- purpose_id — BIGINT — NOT NULL
- template_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
template_variable
- id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — NOT NULL
- variable_key — VARCHAR(100)
- placeholder — VARCHAR(100)
- input_type — VARCHAR(50)
- created_at — TIMESTAMP
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- locked — TINYINT — NOT NULL
- locked_at — DATETIME
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_role_mapping
- user_id — BIGINT — Primary key — NOT NULL
- role_id — BIGINT — Primary key — NOT NULL