CREATE TABLE produk_perusahaan (
	id_produk serial PRIMARY KEY,
	nama_produk text,
	jenis_sajian int,
	komposisi text,
	kemasan text,
	FOREIGN KEY (jenis_sajian) references jenis_sajian(id_sajian)
);

CREATE TABLE jenis_sajian (
	id_sajian serial PRIMARY KEY,
	nama_sajian text
);

INSERT INTO jenis_sajian (nama_sajian) 
VALUES ('KAPSUL'), ('INJEKSI'), ('SIRUP'), ('DROPS'), ('TABLET');

INSERT INTO jenis_sajian (nama_sajian) 
VALUES ('KAPLET');

INSERT INTO produk_perusahaan (nama_produk, jenis_sajian, komposisi, kemasan)
VALUES ('AB-VASK 5', 5, 'Amlodipine besylate 5 mg', 'Dus, 3 blister @ 10 tablet'),
('AB-VASK 10', 5, 'Amlodipine besylate 10 mg', 'Dus, 3 blister @ 10 tablet'),
('ACLAM', 1, 'Amoxycillin 500 mg + Clavulanic Acid 125 mg', 'Dus, 5 strip @ 6 kaplet'),
('ACLAM', 3, 'Tiap 5 ml : Amoxycillin 125 mg + Clavulanic Acid  31,25 mg', 'Botol 60 ml'),
('ACLAM FORTE', 3, 'Tiap 5 ml : Amoxycillin 250 mg + Clavulanic Acid  62,5 mg', 'Botol 60 ml'),
('ALEGI', 1, 'Dexamethasone 0,5 mg + Dexchlorpheniramine maleat 2 mg', 'Dus, 10 Strip @ 10 kaplet'),
('AMADIAB 1', 5, 'Glimepiride 1 mg', 'Dus, 5 blister @ 10 kaplet'),
('AMADIAB 2', 5, 'Glimepiride 2 mg', 'Dus, 5 blister @ 10 kaplet'),
('AMADIAB 3', 5, 'Glimepiride 3 mg', 'Dus, 5 blister @ 10 kaplet'),
('AMADIAB 4', 5, 'Glimepiride 4 mg', 'Dus, 5 blister @ 10 kaplet'),
('BROMEX', 2, 'Bromhexine HCl 2 mg/ml', 'Dus, 10 ampul @ 2 ml'),
('CAL-95 Kids - SIRUP', 3, 'Tiap 5 ml : Calcium Carbonate 200 mg Vit D3 200 IU + Vit K2 22.5 mcg + Zinc Bisglycinate 7.5 mg + Mg 50 mg', 'Botol 60 ml'),
('DC2', 6, 'UC-II® 40 mg + Vit C 80 mg + Vit D3 400 IU', 'Dus, 5 strip @ 6 kaplet salut selaput'),
('ENOXRIN 4000 IU', 2, 'Enoxaparin sodium 4000 IU', 'Dus, 2 syringe'),
('FASTOR 10', 6, 'Atorvastatin 10 mg', 'Dus, 3 blister @ 10 kaplet'),
('GENOCLOM', 5, 'Clomiphene citrate 50 mg', 'Box 2 strip @ 10 tablet');