N-days-challenge
Tables (9)
dajim (다짐)
- dajim_number (다짐 고유번호) — BIGINT — Primary key — NOT NULL
- member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- room_number (름 고유번호) — BIGINT — Foreign key → room.room_number — NOT NULL
- content (다짐 내용) — VARCHAR
- open (공개 여부) — VARCHAR
- created_date (생성 날짜) — DATETIME
- updated_date (변경 날짜) — DATETIME
emotion (이모션)
- emotion_number (이모션 고유번호) — BIGINT — Primary key — NOT NULL
- dajim_number (다짐 고유번호) — BIGINT — Foreign key → dajim.dajim_number — NOT NULL
- member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- sticker (감정 스티커) — VARCHAR
- created_date (생성 날짜) — DATETIME
- updated_date (변경 날짜) — DATETIME
member (회원)
- member_number (멤버 고유번호) — BIGINT — Primary key — NOT NULL
- authority (권한) — VARCHAR — NOT NULL
- nickname (닉네임) — VARCHAR
- id (아이디) — VARCHAR
- pw (비밀번호) — VARCHAR
- image (프로필사진) — INT
refresh_token (리프레쉬 토큰)
- rt_key (토큰 키) — VARCHAR — Primary key — NOT NULL
- rt_value (토큰 값) — VARCHAR
- created_date (생성일자) — DATETIME
relationship (친구관계)
- relationship_number (친구관계 고유번호) — BIGINT — Primary key — NOT NULL
- user_member_number (사용자 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- friend_member_number (친구 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- requested_date (요청 날짜) — DATETIME
- accepted_date (수락 날짜) — DATETIME
- status (관계 상태) — VARCHAR
report (신고)
- report_number (신고 고유번호) — BIGINT — Primary key — NOT NULL
- dajim_number (다짐 고유번호) — BIGINT — Foreign key → dajim.dajim_number — NOT NULL
- cause (신고 사유) — INT
- is_dajim (다짐 상태) — BIT(1)
- content (다짐 내용) — VARCHAR
room (챌린지룸)
- room_number (룸 고유번호) — BIGINT — Primary key — NOT NULL
- member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- stamp_number (스탬프 고유번호) — BIGINT — Foreign key → stamp.stamp_number — NOT NULL
- dtype (룸 타입) — VARCHAR
- category (챌린지 종류) — VARCHAR
- room_name (룸 이름) — VARCHAR
- pass_count (패스 횟수) — INT
- reward (보상) — VARCHAR
- start_date (시작 날짜) — DATE
- end_date (완료 날짜) — DATE
- status (챌린지 상태) — VARCHAR
room_member (챌린지룸 회원)
- room_member_number (룸멤버 고유번호) — BIGINT — Primary key — NOT NULL
- member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- room_number (룸 고유번호) — BIGINT — Foreign key → room.room_number — NOT NULL
- stamp_number (스탬프 고유번호) — BIGINT — Foreign key → stamp.stamp_number — NOT NULL
stamp (스탬프)
- stamp_number (스탬프 고유번호) — BIGINT — Primary key — NOT NULL
- member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
- room_number (룸 고유번호) — BIGINT
- latest_date (최근 업데이트 날짜) — DATETIME
- success_count (출석 성공 횟수) — INT
- used_pass_count (패스 사용 횟수) — INT
- day (출석 날짜) — VARCHAR