ex1

Tables (4)

Board

  • board (id) — Long — Primary key — NOT NULL
  • board (title) — varchar(10)
  • board (content) — varchar(500)
  • board (createdate) — DateTime
  • board (updatedate) — DateTime
  • user_ (id2) — Long — Foreign key → User.user_ — NOT NULL

City

  • City (id) — Long — Primary key — NOT NULL
  • City (city) — varchar(10)
  • Field

Comment

  • Comment (id) — Long — Primary key — NOT NULL
  • Comment (content) — varchar(500)
  • Comment (createdate) — DateTime
  • Comment (updatedate) — DateTime
  • user_ (id2) — Long — Foreign key → User.user_ — NOT NULL

User

  • user_ (id) — Long — Primary key — NOT NULL
  • user_ (name) — varchar(10)
  • user_ (password) — varchar(10)
  • user_ (age) — int
  • user_ (createDate) — DateTime
  • City (c_id) — Long — Foreign key → City.City — NOT NULL