이런저런 DB ERD
테이블 (10)
Alarms
- alarmId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- category — varchar(150) — NOT NULL
- courseId — varchar(150)
- courseTitle — varchar(150)
- groupId — varchar(150)
- groupTitle — varchar(150)
- nickname — varchar(150)
- role — varchar(100)
- check — tinyint(1) — NOT NULL
- commentId — varchar(150)
- sendPhone — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Appliers
- applyId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- groupId — varchar(150) — 외래 키 → Groups.groupId — NOT NULL
- attendance — tinyint(1) — NOT NULL
- evaluation — int — NOT NULL
Badges
- badgeId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- badge1 — tinyint(1) — NOT NULL
- badge2 — tinyint(1) — NOT NULL
- badge3 — tinyint(1) — NOT NULL
- badge4 — tinyint(1) — NOT NULL
- badge5 — tinyint(1) — NOT NULL
- badge6 — tinyint(1) — NOT NULL
Bookmarks
- bookmarkId — varchar(150) — 기본 키 — NOT NULL
- courseId — varchar(150) — 외래 키 → Courses.courseId — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
Comments
- commentId — varchar(150) — 기본 키 — NOT NULL
- groupId — varchar(150) — 외래 키 → Groups.groupId
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- courseId — varchar(150) — 외래 키 → Courses.courseId
- content — text
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Courses
- courseId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- title — varchar(150) — NOT NULL
- content — text — NOT NULL
- location — varchar(255) — NOT NULL
- distance — float — NOT NULL
- totalTime — datetime — NOT NULL
- courseImageUrl1 — varchar(255) — NOT NULL
- courseImageUrl2 — varchar(255)
- courseImageUrl3 — varchar(255)
- mapLatLng — text — NOT NULL
- starPoint — float
- parking — varchar(255)
- baggage — varchar(255)
- clickCnt — int — NOT NULL
- region — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- thema — varchar(20)
Groups
- groupId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- mapLatLng — text — NOT NULL
- thumbnailUrl1 — varchar(255)
- thumbnailUrl2 — varchar(255)
- thumbnailUrl3 — varchar(255)
- title — varchar(150) — NOT NULL
- maxPeople — int — NOT NULL
- date — date — NOT NULL
- standbyTime — time — NOT NULL
- timecode — int — NOT NULL
- distance — float — NOT NULL
- speed — varchar(50) — NOT NULL
- location — varchar(200) — NOT NULL
- region — int — NOT NULL
- parking — varchar(255)
- baggage — varchar(255)
- content — text
- thema — varchar(20) — NOT NULL
- chattingRoom — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Recomments
- recommentId — varchar(150) — 기본 키 — NOT NULL
- commentId — varchar(150) — 외래 키 → Comments.commentId — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- content — text
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Users
- userId — varchar(150) — 기본 키 — NOT NULL
- nickname — varchar(150) — NOT NULL
- bio — varchar(255)
- profileUrl — varchar(200) — NOT NULL
- likeLocation — varchar(100)
- likeDistance — varchar(50)
- userLevel — varchar(50)
- mannerPoint — float — NOT NULL
- social — varchar(100)
- socialId — varchar(255)
- phone — varchar(100)
- agreeSMS — tinyint(1) — NOT NULL
starpoint
- starPointId — varchar(150) — 기본 키 — NOT NULL
- userId — varchar(150) — 외래 키 → Users.userId — NOT NULL
- courseId — varchar(150) — 외래 키 → Courses.courseId — NOT NULL
- myStarPoint — int