transactionstatus
name VARCHAR(32)description VARCHAR(128)
dealstatusid NUMERIC(10)
dealstatus
name VARCHAR(32)description VARCHAR(128)
payway
paywaystyle VARCHAR(64)
dealid NUMERIC(10)
userid NUMERIC(11)
categoryid NUMERIC(11)
product
name VARCHAR(64)description VARCHAR(4000)categoryid NUMERIC(10)publish VARCHAR(16) images VARCHAR(128)cash NUMERIC(10) ratio NUMERIC(6) deadline NUMERIC(6)
categoryid=categoryid
transactionstatusid NUMERIC(10)
productid NUMERIC(16)
announce
title VARCHAR(64)description VARCHAR(1000)content VARCHAR(8000)images VARCHAR(128)publish VARCHAR(20)
dealstatusid=dealstatusid
pcategory
name VARCHAR(128)description VARCHAR(512)
paywayid NUMERIC(3)
transactionid NUMERIC(10)
user
username VARCHAR(20)password VARCHAR(64)phone VARCHAR(11)state NUMERIC(3)confirm VARCHAR(20)
paywayid=paywayid
tcategory
userid=userid
transaction
username VARCHAR(20)userid NUMERIC(11)transtatusid NUMERIC(3)cost NUMERIC(10)transactionname VARCHAR(20) categoryid NUMERIC(10)paywayid NUMERIC(3)
transtatusid=transactionstatusid
deal
username VARCHAR(20)userid NUMERIC(11)dealstatusid NUMERIC(3)cost NUMERIC(10)dealname VARCHAR(20) paywayid NUMERIC(3)
announceid NUMERIC(16)
