0720_erd

Tables (9)

blacklist

  • id — int — Foreign key → user.id — NOT NULL
  • expiredate — datetime

comment

  • id — int — Primary key — NOT NULL
  • uid — int — Foreign key → user.id — NOT NULL
  • fid — int — Foreign key → feed.id — NOT NULL
  • content — varchar(45)
  • regdate — date
  • editdate — date

commentlike

  • cid — int — Foreign key → comment.id — NOT NULL
  • uid — int — Foreign key → user.id — NOT NULL

feed

  • id — int — Primary key — NOT NULL
  • uid — int — Foreign key → user.id — NOT NULL
  • title — varchar(45)
  • content — varchar(45)
  • regdate — date
  • editdate — date

feedhashtag

  • fid — int — Foreign key → feed.id — NOT NULL
  • hid — int — Foreign key → hashtag.id — NOT NULL

feedlike

  • fid — int — Foreign key → feed.id — NOT NULL
  • uid — int — Foreign key → user.id — NOT NULL

hashtag

  • id — int — Primary key — NOT NULL
  • content — varchar(45) — NOT NULL

relationship

  • relationuid — int — Foreign key → user.id — NOT NULL
  • uid — int — Foreign key → user.id — NOT NULL
  • state — int — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • uid — varchar(45) — NOT NULL
  • upw — varchar(45)
  • unick — varchar(45) — NOT NULL
  • uemail — varchar(45)
  • uregdate — date
  • ubirth — date
  • usex — int
  • roles — varchar(45)