diary

Tables (7)

comment

  • id — int — Primary key — NOT NULL
  • id (id3) — Foreign key → post.id — NOT NULL
  • content (Field)
  • regdate (Field2)
  • updatedate (Field3)
  • userId (id2) — Foreign key → user.id — NOT NULL

follow (CopyOfuser)

  • following (userid) — Foreign key → user.id — NOT NULL
  • follower (targetid) — Foreign key → user.id — NOT NULL
  • regDat (Field)

hashpost

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → hashtag.Key — NOT NULL
  • id — Foreign key → post.id — NOT NULL
  • Field

hashtag (Untitled)

  • Key — Primary key — NOT NULL
  • Field

img

  • id (Key) — Primary key — NOT NULL
  • postId (id) — Foreign key → post.id — NOT NULL
  • src (Field)
  • regDate (Field2)
  • updatedate (Field3)

post

  • id — Primary key — NOT NULL
  • content (userid)
  • regdate (date)
  • updatedate (Field3)
  • userid (id2) — Foreign key → user.id — NOT NULL
  • img (Field)

user

  • id — Primary key — NOT NULL
  • email (userid)
  • password
  • ninkname (Field3)
  • regdate (Field)
  • updatedate (Field2)
  • Field4