doram

Tables (4)

comments (Untitled4)

  • comment_id (PK) — Not Null — Primary key — NOT NULL
  • post_id (PK2) — Not Null — Foreign key → posts.post_id — NOT NULL
  • user_id (PK22) — Not Null — Foreign key → posts.user_id — NOT NULL
  • comment_text (Field) — Null
  • comment_date (Field2) — Null

likes (Untitled3)

  • like_id (PK) — Not Null — Primary key — NOT NULL
  • user_id (FK) — Not Null — Primary key — NOT NULL
  • post_id (Key2) — Not Null — Primary key — NOT NULL
  • like_date (Field) — Null

posts (Untitled2)

  • post_id (PK) — Not Null — Primary key — NOT NULL
  • user_id (PK2) — Not Null — Foreign key → user.user_id — NOT NULL
  • content (Field2) — Not Null
  • post_date (Field3) — Null

user (Untitled)

  • user_id (PK) — Not Null — Primary key — NOT NULL
  • username (Field) — Not Null
  • birth_year (Field2) — Null
  • city (Field3) — Null