alt_v2
Tables (18)
adminimg
- nuuid — Primary key — NOT NULL
- nno — NUMBER — Foreign key → admintable.nno — NOT NULL
- nuploadpath
- nfilename
- nfiletype
admintable
- nno — NUMBER — Primary key — NOT NULL
- ntitle
- ncontent
- nwriter
- nwriteDate — TIMESTAMP
- nupdateDate — TIMESTAMP
basket
- bcode — Primary key — NOT NULL
- cid — Foreign key → client.cid — NOT NULL
- sno — NUMBER — Foreign key → saleboard.sno — NOT NULL
- bdate — TIMESTAMP
- bamount — NUMBER
- bprice — NUMBER
chatmsg
- msgno — NUMBER — Primary key — NOT NULL
- roomno — Foreign key → chatroom.roomno — NOT NULL
- id
- msg
- msgread
- msgdate — TIMESTAMP
chatroom
- roomno — Primary key — NOT NULL
- cid — Foreign key → client.cid — NOT NULL
- vid — Foreign key → vendor.vid — NOT NULL
- roomdate — TIMESTAMP
client
- cid — Primary key — NOT NULL
- cpassword
- cname
- cnick
- cphone
- caddress
- cjoinDate — TIMESTAMP
- creport — NUMBER
- cdelete
- cgrade
- enable — NUMBER
clientauth
- cid — Foreign key → client.cid — NOT NULL
- authority
ord
- ocode — Primary key — NOT NULL
- cid — Foreign key → client.cid — NOT NULL
- oaddress
- ophone
- odate — TIMESTAMP
- opay
ordProduct
- ordProductCode — NUMBER — Primary key — NOT NULL
- ocode — Foreign key → ord.ocode — NOT NULL
- sno — NUMBER — Foreign key → saleboard.sno — NOT NULL
- oamount — NUMBER
- oprice — NUMBER
- oppay
product
- pcode — NUMBER — Primary key — NOT NULL
- pname
reply
- rno — NUMBER — Primary key — NOT NULL
- sno — NUMBER — Foreign key → saleboard.sno — NOT NULL
- rwriter
- rcontent
- rwriteDate — TIMESTAMP
- rupdateDate — TIMESTAMP
- rstar — NUMBER
- rdelete
replyImg
- ruuid — Primary key — NOT NULL
- rno — NUMBER — Foreign key → reply.rno — NOT NULL
- ruploadPath
- rfileName
saleImg
- suuid — Primary key — NOT NULL
- sno — NUMBER — Foreign key → saleboard.sno — NOT NULL
- suploadPath
- sfileName
saleThumbImg
- stuuid (suuid) — Primary key — NOT NULL
- sno — NUMBER — Foreign key → saleboard.sno — NOT NULL
- stuploadPath (suploadPath)
- stfileName (sfileName)
saleboard
- sno — NUMBER — Primary key — NOT NULL
- vid — Foreign key → vendor.vid — NOT NULL
- pcode — NUMBER — Foreign key → product.pcode — NOT NULL
- stitle
- sinfo
- swriteDate — TIMESTAMP
- supdateDate — TIMESTAMP
- sprice — NUMBER
- sdelete
- scount — NUMBER
- samount — NUMBER
vendor
- vid — Primary key — NOT NULL
- vpassword
- vname
- vregisterNo
- vphone
- vaddress
- vjoinDate — TIMESTAMP
- vinfo
- vreport — NUMBER
- vdelete
- vgrade
- enable — NUMBER
vendorauth
- vid — Foreign key → vendor.vid — NOT NULL
- authority
zim
- zimCode — NUMBER — Primary key — NOT NULL
- cid — Foreign key → client.cid — NOT NULL
- sno (sno2) — NUMBER — Foreign key → saleboard.sno — NOT NULL