کد: انتخاب همه
create table ouser.INVENTORIES
(
PRODUCT_ID NUMBER(12) not null
constraint FK_INVENTORIES_PRODUCTS
references ouser.PRODUCTS
on delete cascade,
WAREHOUSE_ID NUMBER(12) not null
constraint FK_INVENTORIES_WAREHOUSES
references ouser.WAREHOUSES
on delete cascade,
QUANTITY NUMBER(8) not null,
constraint PK_INVENTORIES
primary key (PRODUCT_ID, WAREHOUSE_ID)
)
/
create table ouser.PRODUCTS
(
PRODUCT_ID NUMBER generated as identity
primary key,
PRODUCT_NAME VARCHAR2(255) not null,
DESCRIPTION VARCHAR2(2000),
STANDARD_COST NUMBER(9,2),
LIST_PRICE NUMBER(9,2),
CATEGORY_ID NUMBER not null
)
create table ouser.WAREHOUSES
(
WAREHOUSE_ID NUMBER generated as identity
primary key,
WAREHOUSE_NAME VARCHAR2(255),
LOCATION_ID NUMBER(12)
)