wanted

Tables (4)

Member (멤버)

  • id (아이디) — Integer — Primary key — NOT NULL — Auto Generated
  • email (이메일) — varchar(50)
  • password (비밀번호) — varchar(100)
  • created_at (생성시각) — datetime
  • modified_at (수정시각) — datetime

Page (페이지)

  • id (아이디) — Integer — Primary key — NOT NULL
  • title (제목) — varchar(100)
  • content (내용) — blob
  • parent_page_id (상위 페이지 아이디) — Integer

Post (게시물)

  • id (아이디) — Integer — Primary key — NOT NULL — Auto Generated
  • title (이메일) — varchar(150)
  • content (내용) — blob
  • created_at (생성시각) — datetime
  • modified_at (수정시각) — datetime
  • member_id (작성자 아이디) — Integer — Foreign key → Member.id — NOT NULL — Auto Generated

RefreshToken (리프레쉬토큰)

  • email (이메일) — varchar(50) — Primary key — NOT NULL
  • refresh_token (리프레쉬 토큰) — varchar(256) — NOT NULL