Hasil Sql Dari visualparadigm

CREATE TABLE employees (id int(11) NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL, profile_picture varchar(255), code varchar(10) NOT NULL UNIQUE, date_of_birth date NOT NULL, gender int(1) NOT NULL, address text NOT NULL, email varchar(75) NOT NULL, password varchar(75) NOT NULL, phone_num varchar(20) NOT NULL, employment varchar(55) NOT NULL, emp_desc varchar(255) NOT NULL, salary int(11) NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id), INDEX (name));
CREATE TABLE journals (id int(11) NOT NULL AUTO_INCREMENT, employee_id int(11) NOT NULL UNIQUE, `date` datetime NOT NULL, note text NOT NULL, activity_documentation varchar(255) NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id));
CREATE TABLE members (id int(11) NOT NULL AUTO_INCREMENT, name varchar(55) NOT NULL, profile_picture varchar(255), package_id int(11) UNIQUE, code varchar(10) UNIQUE, date_of_birth date, gender int(1), address text, email varchar(255) NOT NULL, password varchar(255) NOT NULL, phone_num varchar(20), join_date datetime NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id), INDEX (name));
CREATE TABLE packages (id int(11) NOT NULL AUTO_INCREMENT, type int(1) NOT NULL, `desc` varchar(50) NOT NULL, price int(11) NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id));
CREATE TABLE payments (id int(11) NOT NULL AUTO_INCREMENT, package_id int(11) NOT NULL UNIQUE, member_id int(11) NOT NULL UNIQUE, `date` datetime NOT NULL, method int(3) NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id));
CREATE TABLE working_times (id int(10) NOT NULL AUTO_INCREMENT, employee_id int(11) NOT NULL, day_of_week int(1) NOT NULL, start_time time NOT NULL, end_time time NOT NULL, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (id));
ALTER TABLE payments ADD CONSTRAINT FKpayments84587 FOREIGN KEY (package_id) REFERENCES packages (id);
ALTER TABLE payments ADD CONSTRAINT FKpayments179948 FOREIGN KEY (member_id) REFERENCES members (id);
ALTER TABLE journals ADD CONSTRAINT FKjournals795900 FOREIGN KEY (employee_id) REFERENCES employees (id);
ALTER TABLE members ADD CONSTRAINT FKmembers85846 FOREIGN KEY (package_id) REFERENCES packages (id);
ALTER TABLE employee_member_relationships ADD CONSTRAINT FKemployee_m664005 FOREIGN KEY (employee_id) REFERENCES employees (id);
ALTER TABLE employee_member_relationships ADD CONSTRAINT FKemployee_m143871 FOREIGN KEY (member_id) REFERENCES members (id);
ALTER TABLE working_times ADD CONSTRAINT FKworking_ti945255 FOREIGN KEY (employee_id) REFERENCES employees (id);
ALTER TABLE attendances ADD CONSTRAINT FKattendance559106 FOREIGN KEY (employee_member_relationship_id) REFERENCES employee_member_relationships (id);