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