Oracle DEMO schema
Tables (8)
DEMO_CUSTOMERS
- CUSTOMER_ID — NUMBER — Primary key — NOT NULL — AAA
- CUST_FIRST_NAME — VARCHAR2(20 BYTE) — NOT NULL — BBB
- CUST_LAST_NAME — VARCHAR2(20 BYTE) — NOT NULL
- CUST_STREET_ADDRESS1 — VARCHAR2(60 BYTE)
- CUST_STREET_ADDRESS2 — VARCHAR2(60 BYTE)
- CUST_CITY — VARCHAR2(30 BYTE)
- CUST_STATE — VARCHAR2(2 BYTE)
- CUST_POSTAL_CODE — VARCHAR2(10 BYTE)
- PHONE_NUMBER1 — VARCHAR2(25 BYTE)
- PHONE_NUMBER2 — VARCHAR2(25 BYTE)
- CREDIT_LIMIT — NUMBER(9,2)
- CUST_EMAIL — VARCHAR2(30 BYTE)
DEMO_ORDERS
- ORDER_ID — NUMBER — Primary key — NOT NULL — A
- CUSTOMER_ID — NUMBER — Foreign key → DEMO_CUSTOMERS.CUSTOMER_ID — NOT NULL
- ORDER_TOTAL — NUMBER(8,2) — 1
- ORDER_TIMESTAMP — DATE
- USER_ID — NUMBER — Foreign key → DEMO_USERS.USER_ID — 3
DEMO_ORDER_ITEMS
- ORDER_ITEM_ID — NUMBER(3) — Primary key — NOT NULL
- ORDER_ID — NUMBER — Foreign key → DEMO_ORDERS.ORDER_ID — NOT NULL
- PRODUCT_ID — NUMBER — Foreign key → DEMO_PRODUCT_INFO.PRODUCT_ID — NOT NULL
- UNIT_PRICE — NUMBER(8,2) — NOT NULL
- QUANTITY — NUMBER(8) — NOT NULL
DEMO_PRODUCT_INFO
- PRODUCT_ID — NUMBER — Primary key — NOT NULL
- PRODUCT_NAME — VARCHAR2(50 BYTE)
- PRODUCT_DESCRIPTION — VARCHAR2(2000 BYTE)
- CATEGORY — VARCHAR2(30 BYTE)
- PRODUCT_AVAIL — VARCHAR2(1 BYTE)
- LIST_PRICE — NUMBER(8,2)
- PRODUCT_IMAGE — BLOB
- MIMETYPE — VARCHAR2(255 BYTE)
- FILENAME — VARCHAR2(400 BYTE)
- IMAGE_LAST_UPDATE — DATE
DEMO_STATES
- ST — VARCHAR2(30 BYTE)
- STATE_NAME — VARCHAR2(30 BYTE)
DEMO_USERS
- USER_ID — NUMBER — Primary key — NOT NULL
- USER_NAME — VARCHAR2(100 BYTE)
- PASSWORD — VARCHAR2(4000 BYTE)
- CREATED_ON — DATE
- QUOTA — NUMBER
- PRODUCTS — CHAR(1 BYTE)
- EXPIRES_ON — DATE
- ADMIN_USER — CHAR(1 BYTE)
DEPT
- DEPTNO — NUMBER(2) — Primary key — NOT NULL
- DNAME — VARCHAR2(14 BYTE)
- LOC — VARCHAR2(13 BYTE)
EMP
- EMPNO — NUMBER(4) — Primary key — NOT NULL
- ENAME — VARCHAR2(10 BYTE)
- JOB — VARCHAR2(9 BYTE)
- MGR — NUMBER(4) — Foreign key → EMP.EMPNO
- HIREDATE — DATE
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- DEPTNO — NUMBER(2) — Foreign key → DEPT.DEPTNO