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)