my_project

Tables (5)

article

  • id — INT — Primary key — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • boardId — INT — Foreign key → board.id — NOT NULL
  • title — VARCHAR
  • place — VARCHAR — NOT NULL
  • placeAddress — VARCHAR — NOT NULL
  • body — TEXT
  • reactionPoint — INT
  • regDate — DATETIME
  • updateDate — DATETIME

board

  • id — INT — Primary key — NOT NULL
  • code — VARCHAR
  • bname — VARCHAR
  • regDate — DATETIME
  • updateDate — DATETIME

comment

  • id — INT — Primary key — NOT NULL
  • relId — INT — Foreign key → article.id — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • comment — TEXT
  • reactionPoint — INT
  • regDate — DATETIME
  • updateDate — DATETIME

member

  • id — INT — Primary key — NOT NULL
  • loginId — VARCHAR
  • loginPw — VARCHAR
  • mname — VARCHAR
  • cellphoneNum — VARCHAR
  • authLevel — TINYINT — 3 - 일반사용자 7 - 관리자
  • regDate — DATETIME
  • updateDate — DATETIME
  • delStatus — TINYINT — 0 - 탈퇴 전 1 - 탈퇴 후
  • delDate — DATETIME — NOT NULL

reactionPoint

  • id — INT — Primary key — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • relId — INT — Foreign key → article.id — NOT NULL
  • comId — INT — Foreign key → comment.id — NOT NULL
  • reactionPoint — INT
  • regDate — DATETIME