DSE

Tables (9)

Category (카테고리)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Follow (팔로우)

  • Uid (follower_id) — int(10) — Foreign key → User.Uid — NOT NULL
  • Uid (following_id) — int(10) — Foreign key → User.Uid — NOT NULL

Hashtag (해쉬태그)

  • Hid (hid) — int(10) — Primary key — NOT NULL
  • Title (title) — varchar(128)

Like (좋아요)

  • Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
  • Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL

Post (게시글)

  • Pid (pid) — int(10) — Primary key — NOT NULL
  • Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
  • Title (title) — varchar(128)
  • Contents (contents) — varchar(5000)
  • Hit (hit) — int(10)
  • Is_hidden (is_hidden) — Boolean
  • Create_date (create_date) — datetime
  • Is_complete (is_complete) — Boolean

Post-Hashtag (연결)

  • Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
  • Hid (hid) — int(10) — Foreign key → Hashtag.Hid — NOT NULL

Recommand (추천)

  • Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
  • Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
  • Count (count) — int(10)

Reply (댓글)

  • Rid (rid) — int(10) — Primary key — NOT NULL
  • Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
  • Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
  • Is_hidden (is_hidden) — Boolean
  • Create_date (create_date) — datetime
  • Reply (reply) — varchar(2000)

User (회원)

  • Uid (uid) — int(10) — Primary key — NOT NULL
  • Uid (following_id) — int(10) — Foreign key → Follow.Uid — NOT NULL
  • Email (email) — varchar(128)
  • Passwrod (password) — varchar(128)
  • Create_date (create_date) — datetime
  • Role (role) — int(2)
  • Nickname (nickname) — varchar(24)
  • Provider (provider) — varchar(10)
  • SNSId (snsid) — varchar(30)