GLAWBAL
Tables (12)
chat_session
- id — INT — Primary key
- user_id — INT — Foreign key → user.id
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_active — BOOLEAN
- summary — CHAR(30)
article
- id — INT — Primary key
- user_id — INT — Foreign key → user.id
- image_id — INT — Foreign key → image.id — NOT NULL
- category_id — INT — Foreign key → category.id — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view — BIGINT
- is_active — TINYINT(1)
category
- id — INT — Primary key — NOT NULL
- major — VARCHAR(30)
- sub — VARCHAR(30)
chat_message
- id — INT — Primary key
- session_id — INT — Foreign key → chat_session.id
- message — TEXT
- sent_at — TIMESTAMP
- sender — INT
comment
- id — INT — Primary key — NOT NULL
- article_id — INT — Foreign key → article.id
- user_id — INT — Foreign key → user.id
- message — VARCHJAR(200)
- created_at — TIMESTAMP
- update_at — TIMESTAMP
faq
- id — INT — Primary key
- question — TEXT
- answer — TEXT
- category — VARCHAR(50)
glossary
- id — INT — Primary key — NOT NULL
- word — VARCHAR(50)
- description — TEXT
- total_view — BIGINT
- week_view — BIGINT
image
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id
- path — VARCHAR(255)
- created_at — TIMESTAMP
law_data
- id — INT — Primary key — NOT NULL
- nation — VARCHAR(50)
- category — VARCHAR(50)
- detail — TEXT
- total_view — BIGINT
- week_view — BIGINT
news
- id — INT — Primary key — NOT NULL
- title — CHAR(255)
- summary — TEXT
- news_link — TEXT
- news_agency — VARCHAR(255)
- timestamp — VARCHAR(100)
- news_content — TEXT
- image_link — TEXT
- total_view — BIGINT
- week_view — BIGINT
rule
- id — INT — Primary key — NOT NULL
- rule — CHAR(100)
- kind — CHAR(20)
- code — CHAR(10)
- ministy — CHAR(30
- history — CHAR(10)
- states (state) — CHAR(20)
- effective — CHAR(10)
- created — CHAR(10)
- content — TEXT
- total_view — BIGINT
- week_view — BIGINT
user
- id — INT — Primary key
- uuid — CHAR(36) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(60) — NOT NULL
- work_at — VARCHAR(50)
- nationality (nation_id) — VARCHAR(50)
- username — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- is_actrive (is_active) — BOOLEAN
- is_staff — BOOLEAN
- is_superuser — BOOLEAN