Приложение 2

Назад

Оглавление

Приложение 2.

Структуры таблиц учебной базы данных
Структура таблицы S_EMP:

SQL> desc 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:

SQL> desc 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:

SQL> desc S_DEPT
Name -----------------------	Null? --------------	Type -------------------
ID		NUMBER(7)
NAME	NOT NULL	VARCHAR2(25)
REGION_ID		NUMBER(7)

Структура таблицы S_ITEM:

SQL> desc 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:

SQL> desc 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:

SQL> desc 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:

SQL> desc S_REGION
Name -----------------------	Null? --------------	Type -------------------
ID		NUMBER(7)
NAME	NOT NULL	VARCHAR2(50)

Структура таблицы S_IMAGE:

SQL> desc 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:

SQL> desc S_TITLE
Name -----------------------	Null? --------------	Type -------------------
TITLE	NOT NULL	VARCHAR2(25)

Структура таблицы S_INVENTORY:

SQL> desc 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

Назад

Оглавление