hanteo

Tables (7)

Board (게시판)

  • board_id (Key) — long — Primary key — NOT NULL
  • group_id (Key2) — Foreign key → Group.group_id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL
  • name (Field) — varchar

Board (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • parent_idx (Field)

Category (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

Group (Untitled2)

  • group_id (Key) — Primary key — NOT NULL
  • name (Field) — varchar
  • gender (Field2) — int

Member (Untitled3)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field)
  • group_id (Key2) — Foreign key → Group.group_id — NOT NULL

Post (Untitled)

  • post_id (Key) — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field3) — text
  • board_id (Key2) — long — Foreign key → Board.board_id — NOT NULL

Post (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • board_id (Key2) — Foreign key → Board.id — NOT NULL