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