erd

Tables (4)

board (Untitled4)

  • b_id (Key) — int — Primary key — NOT NULL
  • userid (Key3) — varchar(20) — Foreign key → users.userid — NOT NULL
  • b_date (Field2) — date
  • status (Field3) — boolean
  • b_title (Field4) — varchar(30)
  • b_detail (Field5) — varchar(400)

items (Untitled3)

  • i_id (Key) — int — Primary key — NOT NULL
  • i_name (Field) — varchar(50)
  • i_stock (Field2) — int
  • i_price (Field3) — int

orders (Untitled2)

  • o_id (Key) — int — Primary key — NOT NULL
  • userid (Key4) — varchar(20) — Foreign key → users.userid — NOT NULL
  • i_id (Key2) — int — Foreign key → items.i_id — NOT NULL
  • o_count (Field) — int
  • o_paid (Field2) — boolean
  • o_date (Field3) — datetime

users (Untitled)

  • userid (Key) — varchar(20) — Primary key — NOT NULL
  • passwd (Field) — varchar(20)
  • name (Field2) — varchar(10)
  • point (Field3) — int
  • adress (Field4) — varchar(100)