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