Create Table Payment Methods

CREATE SEQUENCE methods_sequence AS SMALLINT START 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; CREATE TABLE payment_methods ( id SMALLINT NOT NULL DEFAULT nextval('methods_sequence'::regclass), name VARCHAR(50) NOT NULL, descriptions VARCHAR(128), created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL ); ALTER TABLE ONLY payment_methods ADD CONSTRAINT pk_methods PRIMARY KEY (id); CREATE UNIQUE INDEX uq_method_name ON payment_methods (name); CREATE INDEX methods_ix_payments ON payments USING btree (method_id); CREATE TRIGGER methods_trig_create BEFORE INSERT ON payment_methods FOR EACH ROW EXECUTE FUNCTION timestamp_on_create(); CREATE TRIGGER methods_trig_update BEFORE UPDATE ON payment_methods FOR EACH ROW EXECUTE FUNCTION timestamp_on_update(); ALTER TABLE ONLY payments ADD CONSTRAINT methods_fk_payments FOREIGN KEY (method_id) REFERENCES payment_methods(id) ON UPDATE CASCADE ON DELETE RESTRICT;