CREATE TABLE Product
(
    productId NUMBER (10) PRIMARY KEY,
    name VARCHAR2(60) NOT NULL,
    description VARCHAR2(100),
    price NUMBER (18,2) NOT NULL, --16 numra para presjes, 2 pas presjes
    registerDate DATE NOT NULL
);

--varchar (15) - kjo nuk i rezervon ne memorie
--char (15) - kjo i rezervon ne memorie
--per 10 shkronja, chari i rezervon 15 batje, kurse te varchari 11 bajte (bajti shtes tregon sa karaktere jan rujt, psh 10+1 bajt)
--per 200 shkronja, 200+2 rezervohen ne varchar (2 bajta kallzojn sa karaktere jan rujt)

--nvarchar/nchar (nationalVarchar) per shkronja UNICODE (arabisht, kinez, japan) (karakteret zan hapesire ka 2 bajta)
--varchar edhe char ASCIICODE (shkronjat e vogla + t'mdhaja + numrat + simbole tjera) (256 karaktere i permban) (ç edhe ë te UNICODE)

CREATE TABLE Client
(
    clientId NUMBER (10),
    firstName VARCHAR2 (50) NOT NULL,
    lastName VARCHAR2 (50) NOT NULL,
    tel VARCHAR2 (15),
    email VARCHAR2 (80),
    address VARCHAR2 (80),
    registerDate DATE NOT NULL,

    PRIMARY KEY (clientId)
);

CREATE TABLE PaymentType (
    paymentTypeId NUMBER (10),
    name VARCHAR2 (100) NOT NULL,

    PRIMARY KEY (paymentTypeId)
);

CREATE TABLE Location (
    locationId NUMBER (10),
    address VARCHAR2 (100) NOT NULL,
    email VARCHAR2 (80),
    telephone VARCHAR2 (15),
    PRIMARY KEY (locationId)
);