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)