FreeTalk
Tables (12)
DisLike (dislike)
- u_id — int — Foreign key → user.u_id — NOT NULL
- Type (tableType) — varchar(50)
- type_id — int
HashTag (ht)
- ht_id — int — Primary key — NOT NULL
- ht_name — varchar(100)
Like (like)
- u_id — int — Foreign key → user.u_id — NOT NULL
- Type (tableType) — varchar(50)
- type_id — int
comment (com)
- com_id — int — Primary key — NOT NULL
- w_id — int — Foreign key → writing.w_id — NOT NULL
- com_u_id — int — Foreign key → user.u_id — NOT NULL
- com_contents — varchar(500)
- indate — datetime
- status — varchar(100)
comment_comment (com2)
- com2_id — int — Primary key — NOT NULL
- com_id — int — Foreign key → comment.com_id — NOT NULL
- com2_u_id — int — Foreign key → user.u_id — NOT NULL
- w_id — int — Foreign key → writing.w_id — NOT NULL
- com2_contents — varchar(500)
- indate — datetime
- status — varchar(100)
join
- j_id — int — Primary key — NOT NULL
- c_key — int — Foreign key → user.c_key — NOT NULL
- u_id — int — Foreign key → user.u_id — NOT NULL
- inDate — datetime
tag_relationship (tr)
- ht_id — int — Foreign key → HashTag.ht_id — NOT NULL
- c_key — int — Foreign key → user.c_key — NOT NULL
unknown
- w_id — int — Foreign key → writing.w_id — NOT NULL
- u_id — int — Foreign key → writing.u_id — NOT NULL
- tempName (tn) — int
user (cm)
- c_key — int — Primary key — NOT NULL
- c_name — varchar(100)
- status — varchar(100)
- img — varchar(300)
user
- u_id — int — Primary key — NOT NULL
- email — varchar(100)
- status — varchar(100)
views
- w_id — int — Foreign key → writing.w_id — NOT NULL
- CNT (cnt) — int
- Field
writing (wr)
- w_id — int — Primary key — NOT NULL
- u_id — int — Foreign key → user.u_id — NOT NULL
- c_key — int — Foreign key → user.c_key — NOT NULL
- w_title — varchar(100)
- w_contents — varchar(1000)
- indate — datetime
- status — varchar(100)