camagru

Tables (5)

comment (Untitled4)

  • commentId (Key) — not null — Primary key — NOT NULL
  • comment (Field2) — not null
  • date (Field3) — not null
  • userId (Key2) — not null — Foreign key → user.userId — NOT NULL
  • postId (Key3) — not null — Foreign key → post.postId — NOT NULL

image (Untitled2)

  • imageId (Key) — not null — Primary key — NOT NULL
  • date (Field2) — not null
  • image (Field3) — not null
  • userId (Key2) — not null — Foreign key → user.userId — NOT NULL

like (Untitled5)

  • userId (Key) — not null — Foreign key → user.userId — NOT NULL
  • postId (Key2) — not null — Foreign key → post.postId — NOT NULL

post (Untitled3)

  • postId (Key) — not null — Primary key — NOT NULL
  • date (Field2) — not null
  • likes (Field4)
  • userId (Key2) — not null — Foreign key → user.userId — NOT NULL
  • imageId (Key3) — not null — Foreign key → image.imageId — NOT NULL

user (Untitled)

  • userId (Key) — not null — Primary key — NOT NULL
  • email (Field) — not null
  • username (Field2) — not null
  • password (Field3) — not null
  • auth (Field4) — always/none
  • notice (Field5) — always/none