timing
Tables (8)
alarm
- alarmId — bigint(20) — Primary key — NOT NULL — Alarm 고유 ID
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
- alarmType — int(10) — NOT NULL — 알림 Type
board
- brdId — bigint(20) — Primary key — NOT NULL — board 고유 ID
- brdTitle — varchar(100) — 게시글 제목
- brdContext — text — 게시글 내용
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
- createAt — time — 생성된 시간
- deleteAt — time — 삭제된 시간
character
- ocId — bigint(20) — Primary key — NOT NULL — 캐릭터 고유 ID
- ocName — varchar(100) — NOT NULL — 캐릭터 이름
- ocImg — varchar(100) — NOT NULL — 캐릭터 이미지
coment
- brdId — bigint(20) — Foreign key → board.brdId — NOT NULL
- coContext — text — NOT NULL — 댓글 내용
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
study
- studyId — bigint(20) — Primary key — NOT NULL — study 고유 ID
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
- studyType — varchar(100) — NOT NULL — study Type
- studyTime — varchar(100) — 공부 시간
timing
- timId — bigint(20) — Primary key — NOT NULL — Timing 고유 ID
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
- timDay — varchar(100) — NOT NULL — Timing 진행 날짜
- timType — int(10) — NOT NULL — Timing Type
- timRepeat — tinyint(1) — NOT NULL — Timing 반복 여부
token
- userId — bigint(20) — Foreign key → user.userId — NOT NULL
- reToken — varchar(100)
- createAt — time
user
- userId — bigint(20) — Primary key — NOT NULL — USER 고유 ID
- userName — varchar(100) — NOT NULL — User Nickname
- userDOB — varchar(100) — NOT NULL — user Date of Birth
- userGen — varchar(100) — NOT NULL — user Gender
- profile — varchar(100) — 프로필 사진
- userIntr — text — user 소개
- ocId — bigint(20) — Foreign key → character.ocId — NOT NULL