SpartaTodo

Tables (3)

Card (Untitled2)

  • 카드ID (card_id) — bigint — Primary key — NOT NULL
  • 할일제목 (title) — varchar(255)
  • 할일내용 (content) — varchar(255)
  • 작성자 (name) — varchar(255)
  • 완료여부 (check) — Tinyint(1)
  • 작성일 (wirteDate) — date(6)
  • 완료일 (completeDate) — date(6)
  • 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL

Comment (Untitled3)

  • 댓글ID (comment_id) — Long — Primary key — NOT NULL
  • 작성자 (name) — varchar(255)
  • 댓글내용 (comment_content) — varchar(255)
  • 댓글작성날짜 (comment_writeDay) — date(6)
  • 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
  • 카드ID (card_id) — bigint — Foreign key → Card.카드ID — NOT NULL

User (Untitled)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar(255)
  • 비밀번호 (password) — varchar(255)