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)