bigproject
Tables (10)
article
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- category_id — INT — Foreign key → category.id — NOT NULL
- title — VARCHAR(100)
- body — TEXT
- content_file — VARCHAR(255)
- view — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
category
- id — INT — Primary key — NOT NULL
- major — VARCHAR(30)
- sub — VARCHAR(30)
chat_message
- id — INT — Primary key — NOT NULL
- chat_room_id — INT — Foreign key → chat_room.id — NOT NULL
- message_id — INT — NOT NULL
- input — TEXT — NOT NULL
- output — TEXT — NOT NULL
- timestamp — TIMESTAMP
chat_room
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- room_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
comment
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → article.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- comment_text — VARCHAR(200)
- created_at — TIMESTAMP
file
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → article.id — NOT NULL
- name — VARCHAR(255)
- path — VARCHAR(255)
- width — INT
- height — INT
- byte_size — INT
glossary
- id — INT — Primary key — NOT NULL
- word — VARCHAR(50)
- description — TEXT
- view — BIGINT
law_data
- id — INT — Primary key — NOT NULL
- nation — VARCHAR(48)
- category — VARCHAR(30)
- body — TEXT
- view — BIGINT
user
- id — INT — Primary key — NOT NULL
- uuid — CHAR(36) — NOT NULL
- username — VARCHAR(50)
- password — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(20)
- nationality — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP