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)