게시판

테이블 (22)

BOARD

  • BOARDNUM — NUMBER(10,0)
  • BOARDOPTION — NVARCHAR2(15)
  • BOARDANSWERED — NVARCHAR2(20)
  • BOARDTITLE — NVARCHAR2(60)
  • CUSTOMERID — NVARCHAR2(15)
  • BOARDDATE — DATE
  • BOARDCONTENT — NVARCHAR2(2000)
  • BOARDHIT — NUMBER(10,0)
  • BOARDCONDITION — NVARCHAR2(6)
  • ORDERID — NUMBER
  • BOARDGROUP — NUMBER(10,0)
  • BOARDSTEP — NUMBER(10,0)
  • BOARDINDENT — NUMBER(10,0)
  • BOARDDEL — NVARCHAR2(6)
  • PRODUCTID — NUMBER
  • BOARDETC1 — NVARCHAR2(20)

CART

  • CARTID — NUMBER(10,0)
  • USERID — VARCHAR2(20 BYTE)
  • PRODUCTID — NUMBER(5,0)
  • PRODUCTNAME — VARCHAR2(300 BYTE)
  • QUANTITY — NUMBER(5,0)
  • PRICE2 — NUMBER(10,2)
  • INDATE — DATE
  • PICTURE — VARCHAR2(300 BYTE)

CATEGORIES

  • CATEGORYID — NUMBER
  • CATEGORYNAME — VARCHAR2(15 BYTE)
  • DESCRIPTION — VARCHAR2(300 BYTE)
  • PICTURE — VARCHAR2(3000 BYTE)

CHATTING

  • CHAT_ARTICLE — NVARCHAR2(150)
  • CHAT_TIME — TIMESTAMP

CUSTOMERCUSTOMERDEMO

  • CUSTOMERID — CHAR(5 BYTE) — 외래 키 → CUSTOMERS.CUSTOMERID
  • CUSTOMERTYPEID — CHAR(10 BYTE) — 외래 키 → CUSTOMERDEMOGRAPHICS.CUSTOMERTYPEID

CUSTOMERDEMOGRAPHICS

  • CUSTOMERTYPEID — CHAR(10 BYTE)
  • CUSTOMERDESC — LONG

CUSTOMERS

  • CUSTOMERID — CHAR(5 BYTE)
  • COMPANYNAME — VARCHAR2(40 BYTE)
  • CONTACTNAME — VARCHAR2(30 BYTE)
  • CONTACTTITLE — VARCHAR2(30 BYTE)
  • ADDRESS — VARCHAR2(60 BYTE)
  • CITY — VARCHAR2(15 BYTE)
  • REGION — VARCHAR2(15 BYTE)
  • POSTALCODE — VARCHAR2(10 BYTE)
  • COUNTRY — VARCHAR2(15 BYTE)
  • PHONE — VARCHAR2(24 BYTE)
  • FAX — VARCHAR2(24 BYTE)

EMPLOYEES

  • EMPLOYEEID — NUMBER
  • LASTNAME — VARCHAR2(20 BYTE)
  • FIRSTNAME — VARCHAR2(10 BYTE)
  • TITLE — VARCHAR2(30 BYTE)
  • TITLEOFCOURTESY — VARCHAR2(25 BYTE)
  • BIRTHDATE — DATE
  • HIREDATE — DATE
  • ADDRESS — VARCHAR2(60 BYTE)
  • CITY — VARCHAR2(15 BYTE)
  • REGION — VARCHAR2(15 BYTE)
  • POSTALCODE — VARCHAR2(10 BYTE)
  • COUNTRY — VARCHAR2(15 BYTE)
  • HOMEPHONE — VARCHAR2(24 BYTE)
  • EXTENSION — VARCHAR2(4 BYTE)
  • PHOTO — VARCHAR2(255 BYTE)
  • NOTES — VARCHAR2(600 BYTE)
  • REPORTSTO — NUMBER — 외래 키 → EMPLOYEES.EMPLOYEEID
  • PHOTOPATH — VARCHAR2(3000 BYTE)

EMPLOYEETERRITORIES

  • EMPLOYEEID — NUMBER — 외래 키 → EMPLOYEES.EMPLOYEEID
  • TERRITORYID — VARCHAR2(20 BYTE) — 외래 키 → TERRITORIES.TERRITORYID

FILE_BOARD

  • FILENO — NUMBER(6,0)
  • BOARDNUM — NUMBER(6,0)
  • FILEORGNAME — NVARCHAR2(260)
  • FILENEWNAME — NVARCHAR2(36)
  • FILESIZE — VARCHAR2(30 BYTE)
  • FILEDATE — DATE
  • FILEDEL — NVARCHAR2(2)
  • FILEETC1 — NVARCHAR2(20)
  • FILEETC2 — NVARCHAR2(20)

LOOKUPDATE

  • CUSTOMERID — CHAR(5 BYTE) — 외래 키 → CUSTOMERS.CUSTOMERID
  • ORDERID — NUMBER — 외래 키 → ORDERS.ORDERID
  • APPLICATIONDATE — TIMESTAMP
  • FINISHDATE — TIMESTAMP
  • TYPE — CHAR(10 BYTE)

NEWCUSTOMER

  • NEWNUM — NUMBER(10,0)
  • NEWID — NVARCHAR2(30)
  • NEWPW — NVARCHAR2(30)
  • NEWNAME — NVARCHAR2(60)
  • NEWDATE — DATE
  • NEWPHONE — NVARCHAR2(90)
  • NEWEMAIL — NVARCHAR2(90)
  • NEWRANK — NVARCHAR2(40)
  • NEWDEL — NVARCHAR2(6)
  • NEWETC1 — NVARCHAR2(20)

ORDERDETAILS

  • ORDERID — NUMBER — 외래 키 → ORDERS.ORDERID
  • PRODUCTID — NUMBER — 외래 키 → PRODUCTS.PRODUCTID
  • UNITPRICE — NUMBER
  • QUANTITY — NUMBER
  • DISCOUNT — NUMBER

ORDERS

  • ORDERID — NUMBER
  • CUSTOMERID — CHAR(5 BYTE) — 외래 키 → CUSTOMERS.CUSTOMERID
  • EMPLOYEEID — NUMBER — 외래 키 → EMPLOYEES.EMPLOYEEID
  • TERRITORYID — VARCHAR2(20 BYTE) — 외래 키 → TERRITORIES.TERRITORYID
  • ORDERDATE — DATE
  • REQUIREDDATE — DATE
  • SHIPPEDDATE — DATE
  • SHIPVIA — NUMBER — 외래 키 → SHIPPERS.SHIPPERID
  • FREIGHT — NUMBER
  • SHIPNAME — VARCHAR2(40 BYTE)
  • SHIPADDRESS — VARCHAR2(60 BYTE)
  • SHIPCITY — VARCHAR2(15 BYTE)
  • SHIPREGION — VARCHAR2(15 BYTE)
  • SHIPPOSTALCODE — VARCHAR2(10 BYTE)
  • SHIPCOUNTRY — VARCHAR2(15 BYTE)

PRODUCTS

  • PRODUCTID — NUMBER
  • PRODUCTNAME — VARCHAR2(40 BYTE)
  • SUPPLIERID — NUMBER — 외래 키 → SUPPLIERS.SUPPLIERID
  • CATEGORYID — NUMBER — 외래 키 → CATEGORIES.CATEGORYID
  • QUANTITYPERUNIT — VARCHAR2(20 BYTE)
  • UNITPRICE — NUMBER
  • UNITSINSTOCK — NUMBER
  • UNITSONORDER — NUMBER
  • REORDERLEVEL — NUMBER
  • DISCONTINUED — NUMBER(1,0)
  • PICTURE — VARCHAR2(3000 BYTE)

REGION

  • REGIONID — NUMBER
  • REGIONDESCRIPTION — CHAR(50 BYTE)

REPLY

  • REPLYNUM — NUMBER(6,0)
  • REPLYNAME — VARCHAR2(10 BYTE)
  • BOARDNUM — NUMBER(6,0)
  • REPLYCONTENT — VARCHAR2(90 BYTE)
  • REPLYDATE — DATE
  • REPLYGROUP — NUMBER
  • REPLYSTEP — NUMBER
  • REPLYINDENT — NUMBER
  • REPLYDEL — NVARCHAR2(2)
  • REPLYETC1 — NVARCHAR2(20)
  • REPLYETC2 — NVARCHAR2(20)

SHIPPERS

  • SHIPPERID — NUMBER
  • COMPANYNAME — VARCHAR2(40 BYTE)
  • PHONE — VARCHAR2(24 BYTE)

SUPPLIERS

  • SUPPLIERID — NUMBER
  • COMPANYNAME — VARCHAR2(40 BYTE)
  • CONTACTNAME — VARCHAR2(30 BYTE)
  • CONTACTTITLE — VARCHAR2(30 BYTE)
  • ADDRESS — VARCHAR2(60 BYTE)
  • CITY — VARCHAR2(15 BYTE)
  • REGION — VARCHAR2(15 BYTE)
  • POSTALCODE — VARCHAR2(10 BYTE)
  • COUNTRY — VARCHAR2(15 BYTE)
  • PHONE — VARCHAR2(24 BYTE)
  • FAX — VARCHAR2(24 BYTE)
  • HOMEPAGE — VARCHAR2(200 BYTE)

TERRITORIES

  • TERRITORYID — VARCHAR2(20 BYTE)
  • TERRITORYDESCRIPTION — CHAR(50 BYTE)
  • REGIONID — NUMBER — 외래 키 → REGION.REGIONID

TMP_BOARD

  • BOARDNUM — NUMBER(10,0)
  • BOARDOPTION — NVARCHAR2(15)
  • BOARDANSWERED — NVARCHAR2(20)
  • BOARDTITLE — NVARCHAR2(60)
  • CUSTOMERID — NVARCHAR2(15)
  • BOARDDATE — DATE
  • BOARDCONTENT — NVARCHAR2(2000)
  • BOARDHIT — NUMBER(10,0)
  • BOARDCONDITION — NVARCHAR2(6)
  • ORDERID — NVARCHAR2(20)
  • BOARDGROUP — NUMBER(10,0)
  • BOARDSTEP — NUMBER(10,0)
  • BOARDINDENT — NUMBER(10,0)
  • BOARDDEL — NVARCHAR2(6)
  • PRODUCTID — NUMBER
  • BOARDETC1 — NVARCHAR2(20)

mvc_board

  • bId — number(4)
  • bName — varchar2(20)
  • bTitle — varchar2(200)
  • bContent — varchar2(800)
  • bDate — Date
  • bHit — number(4)
  • bGroup — number(4)
  • bStep — number(4)
  • bIndent — number(4)