12121
Tables (4)
buy
- bu_num — int — Primary key — NOT NULL
- bu_amount — int
- bu_date — datetime
- bu_state — varchar(10)
- bu_us_id — varchar(13)
- bu_it_num (us_id2) — int — NOT NULL
- bu_it_price (Field) — int
- bu_it_name (Field2) — varchar(45)
category
- ca_num — varchar(8) — Primary key — NOT NULL
- ca_name — varchar(20)
item (goods)
- it_num (gd_num) — int — Primary key — NOT NULL
- it_name (gd_title) — varchar(255)
- it_price (gd_price) — int
- it_at_stat (gd_amount) — int
- gd_ca_num — varchar(8)
- ca_num2 — varchar(8) — NOT NULL
- bu_num — int — NOT NULL
user
- us_id — varchar(12) — Primary key — NOT NULL
- us_pass (us_pw) — varchar(255)
- us_CardNum (us_num) — varchar(25)
- us_name — varchar(10)
- us_email — varchar(15)
- us_point — varchar(45)