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