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)