New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Penyempurnaan Mentoring : Ditambah role PJ Mentoring (bisa melihat, seluruh kelompok mentoring) #391

Closed
wildanm opened this Issue Aug 25, 2016 · 2 comments

Comments

Projects
None yet
1 participant
@wildanm
Member

wildanm commented Aug 25, 2016

Ditambah role : PJ Mentoring (bisa melihat, seluruh kelompok mentoring)

@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Oct 3, 2016

Member

Jalankan SQL berikut :

CREATE TABLE pj_mentoring
(
    id INTEGER  NOT NULL AUTO_INCREMENT,
    kd_unit_kerja VARCHAR(50)  NOT NULL,
    tahun_ajaran VARCHAR(4)  NOT NULL,
    nip VARCHAR(20)  NOT NULL,
    PRIMARY KEY (id),
    KEY nip(nip),
    KEY kd_unit_kerja(kd_unit_kerja),
    KEY tahun_ajaran(tahun_ajaran),
    CONSTRAINT pj_mentoring_FK_1
        FOREIGN KEY (kd_unit_kerja)
        REFERENCES kode_unit_kerja (kd_unit_kerja)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT,
    CONSTRAINT pj_mentoring_FK_2
        FOREIGN KEY (nip)
        REFERENCES pegawai (nip)
        ON UPDATE CASCADE
)Engine=InnoDB DEFAULT CHARSET=latin1 ;
Member

wildanm commented Oct 3, 2016

Jalankan SQL berikut :

CREATE TABLE pj_mentoring
(
    id INTEGER  NOT NULL AUTO_INCREMENT,
    kd_unit_kerja VARCHAR(50)  NOT NULL,
    tahun_ajaran VARCHAR(4)  NOT NULL,
    nip VARCHAR(20)  NOT NULL,
    PRIMARY KEY (id),
    KEY nip(nip),
    KEY kd_unit_kerja(kd_unit_kerja),
    KEY tahun_ajaran(tahun_ajaran),
    CONSTRAINT pj_mentoring_FK_1
        FOREIGN KEY (kd_unit_kerja)
        REFERENCES kode_unit_kerja (kd_unit_kerja)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT,
    CONSTRAINT pj_mentoring_FK_2
        FOREIGN KEY (nip)
        REFERENCES pegawai (nip)
        ON UPDATE CASCADE
)Engine=InnoDB DEFAULT CHARSET=latin1 ;
@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Oct 4, 2016

Member

Done in b235504 (bitbucket)

Member

wildanm commented Oct 4, 2016

Done in b235504 (bitbucket)

@wildanm wildanm closed this Oct 4, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment