semi

Tables (5)

center

  • seq — number
  • id — REFERENCES
  • title — varchar(20)
  • content — varchar(500)
  • view_count — number

comment

  • sender — varchar(20)
  • content — varchar(500)
  • write_date — timestamp

goods

  • seq — number
  • name — varchar(20) — NOT NULL
  • price — number — NOT NULL
  • id — REFERENCES
  • img — varchar(100)
  • write_date — timestamp
  • view_count — number

member

  • id — varchar(20) — NOT NULL
  • seq — number
  • pw — varchar(256) — NOT NULL
  • email — varchar(20) — NOT NULL
  • mileage — number
  • black_list — boolean — NOT NULL
  • admin — boolean

note

  • sender — varchar(20)
  • receiver — varchar(20)
  • content — varchar(500)
  • write_date — timestamp