0102DB_DB_EX_FreeBoard

Tables (3)

freeboard (게시판)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • users (Key2) — Long — Foreign key → users.id — NOT NULL
  • cre_date (Field3) — date
  • mod_date (Field4) — date

reple (댓글)

  • id (Key) — int — Primary key — NOT NULL
  • freeboard (Key2) — int — Foreign key → freeboard.id — NOT NULL
  • content (Field) — varchar
  • users (Key3) — int — Foreign key → users.id — NOT NULL

users (사용자)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar