DATABASE

CREATE TABLE bot_service(
bot_service_id CHAR (5) NOT NULL PRIMARY KEY,
bot_service_name VARCHAR (25) NOT NULL
);

CREATE TABLE customer(
customer_id CHAR (5) NOT NULL PRIMARY KEY,
customer_name VARCHAR (30) NOT NULL,
customer_gender VARCHAR (10) NOT NULL,
customer_phone VARCHAR (15) NULL,
customer_address VARCHAR (255) NULL,
customer_date_born VARCHAR (50) NOT NULL,
bot_service_id CHAR (5) NOT NULL,
FOREIGN KEY (bot_service_id) REFERENCES bot_service(bot_service_id)
);

CREATE TABLE staff(
staff_id CHAR (5) NOT NULL PRIMARY KEY,
staff_name VARCHAR (30) NOT NULL,
staff_gender VARCHAR (10) NOT NULL,
staff_phone VARCHAR (15) NOT NULL,
staff_position VARCHAR (30) NOT NULL,
staff_salary VARCHAR (15) NOT NULL
);

CREATE TABLE FAQ(
F_id CHAR (5) NOT NULL PRIMARY KEY,
bot_service_id CHAR (5) NOT NULL,
FOREIGN KEY (bot_service_id) REFERENCES bot_service(bot_service_id),
F_name VARCHAR (30) NOT NULL,
F_type VARCHAR (30) NOT NULL
);

CREATE TABLE info(
info_id CHAR (5) NOT NULL PRIMARY KEY,
bot_service_id CHAR (5) NOT NULL,
FOREIGN KEY (bot_service_id) REFERENCES bot_service(bot_service_id),
info_name VARCHAR (30) NOT NULL,
info_type VARCHAR (30) NOT NULL
);

CREATE TABLE rekening(
rek_id CHAR (5) NOT NULL PRIMARY KEY,
staff_id CHAR (5) NOT NULL,
FOREIGN KEY (staff_id) REFERENCES staff(staff_id),
bot_service_id CHAR (5) NOT NULL,
FOREIGN KEY (bot_service_id) REFERENCES bot_service(bot_service_id),
rek_service VARCHAR (30) NOT NULL,
CONSTRAINT fk_staff_id FOREIGN KEY (staff_id) REFERENCES staff,
CONSTRAINT fk_bot_service_id FOREIGN KEY (bot_service_id) REFERENCES bot_service
);

CREATE TABLE transaksi(
transaksi_id CHAR (5) NOT NULL PRIMARY KEY,
rek_id CHAR (5) NOT NULL,
FOREIGN KEY (rek_id) REFERENCES rekening (rek_id),
transaksi_pelayanan VARCHAR (30) NOT NULL
);

CREATE TABLE transfer(
transfer_id CHAR (5) NOT NULL PRIMARY KEY,
transaksi_id CHAR (5) NOT NULL,
FOREIGN KEY (transaksi_id) REFERENCES transaksi (transaksi_id),
transfer_pelayanan VARCHAR (30) NOT NULL
);