tt
Tables (4)
account
- account_id — bigint — NOT NULL
- user_id — varchar(30) — NOT NULL
- name — varchar(30) — NOT NULL
- role — varchar(15) — NOT NULL
category
- category_id — bigint — NOT NULL
- name — varchar(30) — NOT NULL
- parent_id — bigint
- created — date` — NOT NULL
- last_modified_date — datetime — NOT NULL
history
- history_id — bigint — NOT NULL
- fk_mail_template_id — bigint — NOT NULL
- message — varchar(255)
- by — varchar(30) — NOT NULL
- time — datetime — NOT NULL
mail_template
- mail_template_id — bigint — NOT NULL
- subject — varchar(50)
- description — varchar(255)
- keys — varchar(255)
- content — MEDIUMTEXT — NOT NULL
- fk_category_id — bigint — NOT NULL
- state — enum('ACTIVE', 'INACTIVE','DELETED') — NOT NULL