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)