|
|
 |
Структура таблицы S_EMP:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| LAST_NAME |
NOT NULL |
VARCHAR2(25) |
| FIRST_NAME |
|
VARCHAR2(25) |
| USERID |
NOT NULL |
VARCHAR2(8) |
| START_DATE |
|
DATE |
| COMMENTS |
|
VARCHAR2(25) |
| MANAGER_ID |
|
NUMBER(7) |
| TITLE |
|
VARCHAR2(25) |
| DEPT_ID |
|
NUMBER(7) |
| SALARY |
|
NUMBER(11,2) |
|
COMMISSION_PCT |
|
NUMBER(4,2) |
Структура таблицы S_CUSTOMER:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| NAME |
NOT NULL |
VARCHAR2(50) |
| PHONE |
|
VARCHAR2(25) |
| ADDRESS |
|
VARCHAR2(400) |
| CITY |
|
VARCHAR2(30) |
| STATE |
|
VARCHAR2(20) |
| COUNTRY |
|
VARCHAR2(30) |
| ZIP_CODE |
|
VARCHAR2(75) |
|
CREDIT_RATING |
|
VARCHAR2(9) |
| SALES_REP_ID |
|
NUMBER(7) |
| REGION_ID |
|
NUMBER(7) |
| COMMENTS |
|
VARCHAR2(255) |
Структура таблицы S_DEPT:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| NAME |
NOT NULL |
VARCHAR2(25) |
| REGION_ID |
|
NUMBER(7) |
Структура таблицы S_ITEM:
| Name |
Null? |
Type |
| ORD_ID |
|
NUMBER(7) |
| ITEM_ID |
|
NUMBER(7) |
| PRODUCT_ID |
|
NUMBER(7) |
| PRICE |
|
NUMBER(11,2) |
| QUANTITY |
|
NUMBER(9) |
|
QUANTITY_SHIPPED |
|
NUMBER(9) |
Структура таблицы S_ORD:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| CUSTOMER_ID |
NOT NULL |
NUMBER(7) |
| DATE_ORDERED |
|
DATE |
| DATE_SHIPPED |
|
DATE |
| SALES_REP_ID |
|
NUMBER(7) |
| TOTAL |
|
NUMBER(11,2) |
| PAYMENT_TYPE |
|
VARCHAR2(6) |
| ORDER_FILLED |
|
VARCHAR2(1) |
Структура таблицы S_PRODUCT:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| NAME |
NOT NULL |
VARCHAR2(50) |
| SHORT_DESC |
|
VARCHAR2(255) |
| LONGTEXT_ID |
|
NUMBER(7) |
| IMAGE_ID |
|
NUMBER(7) |
|
SUGGESTED_WHLSL_PRICE |
|
NUMBER(11,2) |
| WHLSL_UNITS |
|
VARCHAR2(25) |
Структура таблицы S_REGION:
| Name |
Null? |
Type |
| ID |
|
NUMBER(7) |
| NAME |
NOT NULL |
VARCHAR2(50) |
Структура таблицы S_IMAGE:
| Name |
Null? |
Type |
| ID |
NOT NULL |
NUMBER(7) |
| FORMAT |
|
VARCHAR2(25) |
| USE_FILENAME |
|
VARCHAR2(25) |
| FILENAME |
|
VARCHAR2(25) |
| IMAGE |
|
LONG RAW |
Структура таблицы S_TITLE:
| Name |
Null? |
Type |
| TITLE |
NOT NULL |
VARCHAR2(25) |
Структура таблицы S_INVENTORY:
| Name |
Null? |
Type |
| PRODUCT_ID |
|
NUMBER(7) |
| WAREHOUSE_ID |
NOT NULL |
NUMBER(7) |
|
AMOUNT_IN_STOCK |
|
NUMBER(9) |
|
REORDER_POINT |
|
NUMBER(9) |
| MAX_IN_STOCK |
|
NUMBER(9) |
|
OUT_OF_STOCK_EXPLANATION |
|
VARCHAR2(255) |
| RESTOCK_DATE |
|
DATE |
|
|
