게시판

테이블 (3)

Comment (댓글)

  • id — Long — 기본 키 — NOT NULL
  • comment — text
  • created_date (Field2) — DateTime
  • updated_date (Field3) — DateTime
  • user_id (Key3) — Long — 외래 키 → User.id — NOT NULL
  • posts_id (Key2) — Long — 외래 키 → Posts.id — NOT NULL

Posts (게시글)

  • id (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — varchar
  • content (Field2) — text
  • writer (Field3) — varchar
  • view (Field4) — int
  • created_date (Field5) — DateTime
  • updated_date (Field6) — DateTime
  • user_id (Key2) — Long — 외래 키 → User.id — NOT NULL

User (사용자)

  • id (Key) — Long — 기본 키 — NOT NULL
  • name (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • email (Field4) — varchar
  • created_date (Field5) — DateTime
  • updated_date (Field6) — DateTime