MyStyling

Tables (9)

Article (Untitled4)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • FK (userId) — bigInt(20) — Foreign key → User.고유값 — NOT NULL
  • FK (categoryId) — bigInt(20) — Foreign key → Category.고유값 — NOT NULL
  • 제목 (title) — varchar
  • 상세정보 (description) — varchar
  • 조회수 (view_count) — INT
  • 작성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

Article_Tag (Untitled7)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • FK (tag_id) — bigInt(20) — Foreign key → Tag.고유값 — NOT NULL
  • FK (Article_id) — bigInt(20) — Foreign key → Article.고유값 — NOT NULL

Category (Untitled5)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • 카테고리 명 (name) — varchar
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

Chatting (Untitled3)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • 메시지 (message) — varchar
  • 읽음 여부 (isRead) — Boolean
  • FK (user_id) — bigInt(20) — Foreign key → User.고유값 — NOT NULL
  • FK (room_id) — bigInt(20) — Foreign key → Room.Key — NOT NULL

ExpertUser (Untitled6)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 전문분야 (specialty) — varchar
  • Field2 (info) — varchar
  • 자격증 인증 (certification) — Boolean
  • FK (user_id) — bigInt(20) — Foreign key → User.고유값 — NOT NULL

Interior

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • 이미지url (url) — varchar
  • 설명 (description) — varchar
  • Field

Room

  • Key (id) — bigInt(20) — Primary key — NOT NULL
  • FK (UserId) — bigInt(20) — Foreign key → User.고유값 — NOT NULL

Tag (Untitled2)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • Tag 명 (name) — varchar
  • 슬러그 (slug) — varchar
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

User (Untitled)

  • 고유값 (id) — bigInt(20) — Primary key — NOT NULL
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 닉네임 (nickname) — varchar