게시판
테이블 (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)