NoticeBoard

Tables (3)

Comment (Untitled3)

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.id — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • create_data — DATETIME
  • update_data — DATETIME
  • content — STRING

Member (Untitled)

  • member_id — INT — Primary key — NOT NULL
  • email — VARCHAR(30)
  • password — VARCHAR(30)
  • nickname — VARCHAR(30)
  • create_data — DATETIME
  • update_date — DATETIME

Post (Untitled2)

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • create_data — DATETIME
  • update_data — DATETIME
  • title — VARCHAR(20)
  • content — STRING