tabbel penilaian kebertan sementara
unknown
plain_text
a year ago
990 B
2
Indexable
Never
CREATE TABLE skp_penilaian_keberatan ( id varchar(32) NOT NULL, skp_penilaian_id varchar(32) NOT NULL, keberatan varchar(200) DEFAULT NULL, penjelasan_penilai varchar(200) DEFAULT NULL, keputusan_atasan varchar(200) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NULL DEFAULT NULL, deleted_at timestamp NULL DEFAULT NULL, periode varchar(255) NOT NULL, tahun varchar(45) NOT NULL, PRIMARY KEY (id), KEY fk_skp_penilaian_keberatan_skp_penilaian1_idx (skp_penilaian_id), KEY fk_skp_penilaian_keberatan_ref_periode1_idx (periode), CONSTRAINT fk_skp_penilaian_keberatan_skp_penilaian1 FOREIGN KEY (skp_penilaian_id) REFERENCES skp_penilaian (id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_skp_penilaian_keberatan_ref_periode1 FOREIGN KEY (periode) REFERENCES ref_periode (id) ON DELETE SET NULL ON UPDATE RESTRICT, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;