IssueTrend

Tables (7)

article

  • Key (article_code) — int — Primary key — NOT NULL
  • Field (title) — VARCHAR(500)
  • Field (text) — VARCHAR(10000)
  • Field (created_date) — DATETIME
  • Field (news_agency) — VARCHAR(50)
  • Field (img) — VARCHAR(2500)
  • Field (article_rink) — VARCHAR(2500)

article_comments (Untitled2)

  • Key (comment_id) — int — Primary key — NOT NULL
  • Key (user_no) — int — Foreign key → user.Key — NOT NULL
  • Key (article_code) — int — Foreign key → article.Key — NOT NULL
  • Field (text) — VARCHAR(500)

board_post

  • Key (post_no) — int — Primary key — NOT NULL
  • Key (user_no) — int — Foreign key → user.Key — NOT NULL
  • Field (region_name) — VARCHAR(20)
  • Field (text) — VARCHAR(10000)
  • Field (writed_date) — DATETIME
  • Field (img) — VARCHAR(2500)

keywords

  • Key (article_code) — int — Foreign key → article.Key — NOT NULL
  • Field (keyword) — VARCHAR(50)

local_chat

  • Key (area_code) — int — Primary key — NOT NULL
  • Key (user_no) — int — Foreign key → user.Key — NOT NULL
  • Field (region_name) — VARCHAR(20)
  • Field (text) — VARCHAR(300)
  • Field (writed_time) — DATETIME

post_comments

  • Key (comment_id) — int — Primary key — NOT NULL
  • Key (user_no) — int — Foreign key → user.Key — NOT NULL
  • Key (post_no) — int — Foreign key → board_post.Key — NOT NULL
  • Field (writer) — VARCHAR(50)
  • Field (text) — VARCHAR(500)
  • Field (writed_date) — DATETIME

user

  • Key (user_no) — int — Primary key — NOT NULL
  • Field (profile_img) — VARCHAR(1000)
  • Field2 (email) — VARCHAR(100) — NOT NULL
  • Field5 (password) — VARCHAR(50) — NOT NULL
  • Field3 (phone_num) — VARCHAR(20) — NOT NULL
  • Field4 (region_name) — VARCHAR(20) — NOT NULL
  • Field6 (Favorite_keywords) — VARCHAR(20)
  • Field7 (login_path) — VARCHAR(20)