ddingmate-after
Tables (4)
Comment (댓글)
- comment_Id (Key) — Primary key — NOT NULL
- post_Id (Key2) — Foreign key → Post.post_Id — NOT NULL
- member_Id (Key3) — Foreign key → Member.member_Id — NOT NULL
- content (Field)
- parent (Field2)
- isDeleted (Field5)
- createTime (Field3)
- updateTime (Field4)
Mark (찜(즐겨찾기))
- id (Key) — Primary key — NOT NULL
- Member (Key2) — Foreign key → Post.Member — NOT NULL
- Post (Key3) — Foreign key → Member.member_Id — NOT NULL
Member (사용자)
- member_Id (Key) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- name (Field3)
- major (Field4)
- studentId (Field5)
- birth (Field6)
- introduction (Field7)
- univ (Field8)
- categories (Field9)
- role (Field10)
- createTime (Field11)
- updateTime (Field12)
Post (게시글)
- post_Id (Key) — Primary key — NOT NULL
- Member (Key2) — Foreign key → Member.member_Id — NOT NULL
- title (Field2)
- content (Field)
- categories (Field3)
- type (Field4)
- dueDate (Field5)
- number (Field6)
- link (Field7)
- createTime (Field8)
- updateTime (Field9)