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