DOWON
Tables (7)
Analyzer (분석기)
- id (Analyzer_id) — Primary key — NOT NULL
- input (입력문장) — CHAR(500)
- output (출력문장) — CHAR(500)
- word (추출신조어) — CHAR(300)
Comment (댓글)
- id (Comment_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
- id (Post_id) — Foreign key → Post.id — NOT NULL
- content (댓글내용) — CHAR(100)
- date (댓글일자) — DATETIME
Post (게시글)
- id (Post_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
- title (게시글제목) — CHAR(25)
- content (게시글내용) — CHAR(100)
- date (게시글일자) — DATETIME
Request (요청)
- id (Request_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
- title (요청제목) — CHAR(25)
- content (요청내용) — CHAR(100)
- name (요청단어) — CHAR(16)
- date (요청일자) — DATETIME
S_Dictionary (신조어 사전)
- id (SDictionary_id) — Primary key — NOT NULL
- name (단어이름) — CHAR(300)
- mean (뜻) — CHAR(500)
- example (예문) — CHAR(500)
- replace (대체단어) — CHAR(300)
User (사용자)
- id (user_id) — Primary key — NOT NULL
- nickname (닉네임) — CHAR(50)
- email (이메일) — CHAR(50)
- password (비밀번호) — CHAR(16)
- telephone (전화번호) — CHAR(11)
- u_id (아이디) — CHAR(15)
- profile_pic (이미지) — IMAGE
Vote (투표)
- id (Vote_id) — Primary key — NOT NULL
- id (Post_id) — Foreign key → Post.id — NOT NULL
- tag (태그(찬/반)) — BOOLEAN
- date (투표일자) — DATETIME