test2

Tables (4)

board

  • board_code — Integer — Primary key — NOT NULL
  • member_id — Integer — Foreign key → member.member_id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • bip — VARCHAR(255)

comment

  • comment_id — Integer — Primary key — NOT NULL
  • board_code — Integer — Foreign key → board.board_code — NOT NULL
  • member_id — Integer — Foreign key → member.member_id — NOT NULL
  • comment_date — DATETIME
  • comment_content — Text

member

  • member_id — Integer — Primary key — NOT NULL
  • level_id — Integer — Foreign key → member_level.level_id — NOT NULL
  • password — varchar
  • username — Char
  • nickname — Char
  • phone — Integer
  • Field — Email
  • member_ip — VARCHAR(255)

member_level

  • level_id — Integer — Primary key — NOT NULL
  • level — Char