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