jimmunity

Tables (3)

Comment (Untitled3)

  • comment_id (PK) — LONG — Primary key — NOT NULL
  • member_id (FK) — LONG — Foreign key → Member.member_id — NOT NULL
  • post_id (FK2) — LONG — Foreign key → Post.post_id — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

Member (Untitled)

  • member_id (PK) — LONG — Primary key — NOT NULL
  • email (Field) — VARCHAR(30)
  • password (Field2) — VARCHAR(20)
  • name (Field3) — VARCHAR(10)
  • profileImg (Field4) — TEXT
  • introduction (Field5) — TEXT

Post (Untitled2)

  • post_id (PK) — LONG — Primary key — NOT NULL
  • member_id (FK) — LONG — Foreign key → Member.member_id — NOT NULL
  • title (Field) — VARCHAR(30)
  • content (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updateAt (Field4) — DATE