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