요구사항

테이블 (7)

Board (Untitled3)

  • b_no (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — String — 외래 키 → User.user_id — NOT NULL
  • title (Field)
  • author (Field2)
  • created_at (Field3)
  • modified_at (Field4)
  • deleted_at (Field5)
  • like_count (Field6)
  • dislike_count (Field7)
  • view_count (Field8)

Board_like (Untitled5)

  • id (Key3) — 기본 키 — NOT NULL
  • user_id (Key4) — String — 외래 키 → User.user_id — NOT NULL
  • like (Field)
  • dislike (Field2)
  • created_at (Field3)
  • user_id (Key22) — String — NOT NULL
  • b_no (Key) — 외래 키 → Board.b_no — NOT NULL
  • user_id (Key2) — String — 외래 키 → Board.user_id — NOT NULL

Content (Untitled2)

  • c_no (Key) — 기본 키 — NOT NULL
  • b_no (Key2) — 외래 키 → Board.b_no — NOT NULL
  • user_id (Key3) — String — 외래 키 → Board.user_id — NOT NULL
  • text (Field)

User (Untitled)

  • user_id (Key) — String — 기본 키 — NOT NULL
  • Password (Field) — String
  • is_active (Field2) — Bool
  • Email (Field3) — String
  • nickname (Field4) — String
  • auth_YN (Field5) — bool

UserProfile (Untitled7)

  • user_id (Key) — String — 외래 키 → User.user_id — NOT NULL
  • profile_img (Field2)
  • introduction (Field)
  • level (Field3)
  • birthday (Field4)

reply (Untitled4)

  • r_no (Key) — 기본 키 — NOT NULL
  • b_no (Key2) — 외래 키 → Board.b_no — NOT NULL
  • user_id (Key3) — String — 외래 키 → Board.user_id — NOT NULL
  • content (Field)
  • created_at (Field2)
  • modified_at (Field3)
  • deleted_at (Field4)
  • parent_no (Field5)
  • depth (Field6)

reply_like (Untitled6)

  • user_id (Key4) — String — 외래 키 → User.user_id — NOT NULL
  • r_no (Key2) — 외래 키 → reply.r_no — NOT NULL
  • b_no (Key3) — 외래 키 → reply.b_no — NOT NULL
  • dislike (Field2)
  • like (Field)