car

Tables (9)

Comment

  • Comment_ID — INT
  • Post_ID — INT — NOT NULL
  • User_ID — INT — NOT NULL
  • Comment_Content — TEXT — NOT NULL
  • Created_At — TIMESTAMP
  • Updated_At — TIMESTAMP
  • Deleted_At — TIMESTAMP
  • TotalLike — INT
  • parent_comment_id — int
  • mention_user_id — int

CommentLike

  • Comment_ID — INT — Primary key — NOT NULL
  • User_ID — INT — Primary key — NOT NULL
  • Like_Status — BOOLEAN

EmailVerification

  • User_ID — INT — Primary key — NOT NULL
  • Email — VARCHAR(255) — Primary key — NOT NULL
  • Verification_Code — VARCHAR(10) — NOT NULL
  • Purpose — ENUM('signup', 'reset')
  • Created_At — TIMESTAMP
  • Is_Verified — BOOLEAN

Post

  • Post_ID — INT
  • Post_Title — VARCHAR(100) — NOT NULL
  • Post_Content — TEXT — NOT NULL
  • User_ID — INT — NOT NULL
  • Created_At — TIMESTAMP
  • Updated_At — TIMESTAMP
  • Deleted_At — TIMESTAMP
  • TotalCount — INT
  • TotalLike — INT

PostLike

  • Post_ID — INT — Primary key — NOT NULL
  • User_ID — INT — Primary key — NOT NULL
  • Like_Status — BOOLEAN

Term

  • Term_Code — VARCHAR(10)
  • Term_Content — TEXT — NOT NULL

User

  • User_ID — INT
  • Nickname — VARCHAR(50) — NOT NULL
  • Password — VARCHAR(255) — NOT NULL
  • Email — VARCHAR(255) — NOT NULL
  • Phone — VARCHAR(20)
  • Name — VARCHAR(50) — NOT NULL
  • Created_At — TIMESTAMP

UserTerm

  • User_ID — INT — Primary key — NOT NULL
  • Term_Code — VARCHAR(10) — Primary key — NOT NULL
  • Is_Agreed — BOOLEAN
  • Created_At — TIMESTAMP
  • Updated_At — TIMESTAMP

WithdrawnUser

  • User_ID — INT
  • Deleted_At — TIMESTAMP