[عبسي الحمديني]

درت الداتا بيز في الرد الي فات اني لاكن قلتلكم مش داتا بيز احترافيه
الجداول

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));