WhenThen
Tables (3)
Article Model (ARTICLE)
- id — NVARCHAR(100) — Primary key — NOT NULL
- 제목 (title) — NVARCHAR(255) — NOT NULL
- 썸네일 (thumbnail) — MEDIUMBLOB
- 세부내용 (detail) — TEXT — NOT NULL
- URL (url) — TEXT
- 장소 (place) — TEXT
- 시작기간 (start_datetime) — DATETIME
- 끝기간 (end_datetime) — DATETIME
- user_id — NVARCHAR(255) — Foreign key → User Model.id — NOT NULL
Like Model (LIKE)
- id — NVARCHAR(100) — Primary key — NOT NULL
- user_id — NVARCHAR(100) — Foreign key → User Model.id — NOT NULL
- article_id — NVARCHAR(100) — Foreign key → Article Model.id — NOT NULL
User Model (USER)
- id — NVARCHAR(100) — Primary key — NOT NULL
- 유저_아이디 (user_id) — NVARCHAR(100) — NOT NULL
- 이메일 (email) — NVARCHAR(255) — NOT NULL
- 패스워드 (password_sha256) — NVARCHAR(64) — NOT NULL
- 토큰 (refresh_token) — TEXT
- 닉네임 (nickname) — NVARCHAR(255)