كود:
CREATE table Medicine(
MED_ID VARCHAR2(10) NOT NULL PRIMARY KEY,
PRICE NUMBER(6,2),
FACTORY VARCHAR2(25),
QUANTITY NUMBER(5),
NUMBER_SHELF VARCHA2(4));
------------------------------------------------------------------------------------
create table patient(
First_name varchar2(15),
Second_name varchar2(15),
Pat_id VARCHAR2(15),
Pat_cardid VARCHAR2(15),
BOD DATE,
SIXE_M_F VARCHAR2(1),
phone NUMBER(13),
date_created date,
CONSTRAINT Pat_id_pk PRIMARY KEY(Pat_id))
-------------------------------------------------------------------------------------
create table PHARMACIST(
phar_id NUMBER(12) PRIMARY KEY,
First_name varchar2(15),
Second_name varchar2(15),
Phar_cardid VARCHAR2(15),
Occupation varchar2(15),
Nationality varchar2(12),
SIXE_M_F VARCHAR2(1),
BOD DATE,
phone NUMBER(13),
Major varchar2(15),
Address varchar2(30),
Qualification varchar2(15),
date_created date)
--------------------------------------------------------------------------------------------
create table Users(
user_id NUMBER(5) PRIMARY KEY,
username varchar2(15),
password VARCHAR2(30),
creator varchar2(15),
changed_by varchar2(15),
date_changed date,
CREATE_DATE DATE DEFAULT SYSDATE,
secret_question varchar2(10),
secret_answer varchar2(10));
--------------------------------------------------------------------------------------------
CREATE TABLE PURCHASE_ORDER(
ORDER_ID NUMBER(10) PRIMARY KEY,
ORDER_DATE TIMESTAMP WITH LOCAL TIME ZONE,
DISCOUNT NUMBER(4.2));
------------------------------------------------------------------------------------------
CREATE TABLE PURCHASE_SUB(
ORDER_ID NUMBER(10) FOREGIN KEY REFERENCES PURCHASE_ORDER(ORDER_ID),
MED_ID VARCHAR2(15)
EXPIRY DATE,
QTY NUMBER(5));
-------------------------------------------------------------------------------------------
CREATE TABLE SELLING_ORDER(
ORDER_ID NUMBER(10) PRIMARY KEY,
ORDER_DATE TIMESTAMP WITH LOCAL TIME ZONE,
DISCOUNT NUMBER(4.2));
------------------------------------------------------------------------------------------
CREATE TABLE SELLING_SUB(
ORDER_ID NUMBER(10) FOREGIN KEY REFERENCES PURCHASE_ORDER(ORDER_ID),
MED_ID VARCHAR2(15)
QTY NUMBER(5));