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