E-R

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)