msc
Tables (9)
blogs
- blog_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- link — VARCHAR(255) — NOT NULL
- is_delete — BIT(1) — NOT NULL
- content — lONGTEXT
- path_thumbnail — VARCHAR(255)
- created_date — DATETIME
- created_by — VARCHAR(255)
- modifier_date — DATETIME
- modifier_by — VARCHAR(255)
documents
- document_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- status — BIT(1) — NOT NULL
- link — VARCHAR(255) — NOT NULL
- is_delete — BIT(1) — NOT NULL
- content — lONGTEXT
- path_thumbnail — VARCHAR(255)
- created_date — DATETIME
- created_by — VARCHAR(255)
- modifier_date — DATETIME
- modifier_by — VARCHAR(255)
pages
- page_id — BIGINT — Primary key — NOT NULL
- url — VARCHAR(255) — NOT NULL
- is_delete — BIT(1) — NOT NULL
- name — VARCHAR(255)
- header — VARCHAR(255)
- description — VARCHAR(255)
- path_file — VARCHAR(255)
- meta_keyword — VARCHAR(255)
- created_date — DATETIME
- created_by — VARCHAR(255)
- modifier_date — DATETIME
- modifier_by — VARCHAR(255)
questions
- question_id — BIGINT — Primary key — NOT NULL
- service_category_id — BIGINT — Foreign key → service_categories.service_category_id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_delete — BIT(1) — NOT NULL
- title — lONGTEXT — NOT NULL
- name_company — VARCHAR(255) — NOT NULL
- position — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(15) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- business — VARCHAR(255)
- action — INT
- modifier_by — VARCHAR(255)
- modifier_date — DATETIME
- created_by — VARCHAR(255)
- created_date — DATETIME
roles
- role_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
service_categories
- service_category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- type — INT
service_landings
- service_landing_id (service_category_id) — BIGINT — Primary key — NOT NULL
- category_service_id — BIGINT — NOT NULL
- link — VARCHAR(255)
- status — BIT(1)
- created_date — DATETIME
- created_by — VARCHAR(255)
- modifier_date — VARCHAR(255)
- modifier_by — DATETIME
services
- service_id — BIGINT — Primary key — NOT NULL
- service_category_id — BIGINT — Foreign key → service_categories.service_category_id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_delete — BIT(1) — NOT NULL
- content — VARCHAR(255)
- path_file — VARCHAR(255)
- created_date — DATETIME
- created_by — VARCHAR(255)
- modifier_date — DATETIME
- modifier_by — VARCHAR(255)
users
- user_id — BIGINT — Primary key — NOT NULL
- role_id — BIGINT — Foreign key → roles.role_id
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL