relay
Tables (7)
Copy Of Copy Of User4 (RecordDetail)
- idx (recordIdx) — bigint — Foreign key → Copy Of User4.idx — NOT NULL — 기록 인덱스
- id (time) — datetime — NOT NULL — getTimeStamp
- pw (posX) — float — NOT NULL
- createdAt (posY) — float — NOT NULL
- Field (createdAt) — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status — varchar(10) — NOT NULL — DELETED
Copy Of User (Group)
- idx — bigint — Primary key — NOT NULL
- email (name) — varchar(20) — NOT NULL — 그룹명
- Field (info) — varchar(50) — 그룹 정보(간단)
- Field (imgURL) — text
- Field2 (title) — varchar(50) — NOT NULL — 모집 제목
- Field (content) — text — 모집 설명
- Field (acceptAll) — varchar(1) — NOT NULL — N 수동 수락
- Field (maxNum) — int
- Field (goalType) — int — 거리0, 시간1, 속도2
- Field (goal) — int — 단위는 km, min, km/h
- Field (groupStatus) — varchar(10) — NOT NULL — FINISHED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status (postStatus) — varchar(10) — NOT NULL — DELETED
Copy Of User2 (Timetable)
- idx — bigint — Primary key — NOT NULL — 시간표 인덱스
- idx (applyIdx) — bigint — Foreign key → Copy Of User3.idx — NOT NULL — 신청 인덱스
- email (day) — int — NOT NULL — 일0 월1 화2 수3 목4 금5 토6
- Field (start) — datetime — NOT NULL — getTimestamp로 갖고오기
- Field2 (end) — datetime — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status — varchar(10) — NOT NULL — INACTIVE, DELETED
Copy Of User3 (GroupApplication)
- idx — bigint — Primary key — NOT NULL
- idx (groupIdx) — bigint — Foreign key → Copy Of User.idx — NOT NULL
- idx (profileIdx) — bigint — Foreign key → UserProfile.idx — NOT NULL — 프로필 인덱스
- id (comment) — varchar(50) — 지원시 한마디, 방장이나 자동수락은 불필요
- Field2 (isCaptain) — varchar(1) — NOT NULL — 글 직접 작성했을 경우 Y
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status — varchar(10) — NOT NULL — PENDING(대기), REJECTED(방장이), CANCELED(지원자가)
Copy Of User4 (Record)
- idx — bigint — Primary key — NOT NULL — 기록 인덱스
- idx (profileIdx) — bigint — Foreign key → UserProfile.idx — NOT NULL — 프로필 인덱스
- Field (groupIdx) — bigint — NOT NULL — 그룹 인덱스
- id (start) — datetime — 패쓰, 실패시에만 NULL
- pw (end) — datetime
- status (runningStatus) — varchar(10) — NOT NULL — FINISHED, PASS, FAILED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- Field (status) — varchar(10) — NOT NULL — DELETED
User
- idx — bigint — Primary key — NOT NULL
- id — varchar(20) — NOT NULL
- pw — text — NOT NULL
- email — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status — varchar(10) — NOT NULL — INACTIVE, DELETED
UserProfile
- idx — bigint — Primary key — NOT NULL — 프로필 인덱스
- idx (userIdx) — bigint — Foreign key → User.idx — NOT NULL — 유저 인덱스
- nickname — varchar(20) — NOT NULL
- Field (imgURL) — text
- statusMsg — text — 상태메세지
- Field (allowNotice) — varchar(1) — NOT NULL — N 알림 비허용
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- status — varchar(10) — NOT NULL — INACTIVE, DELETED