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