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