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 : Upload Materi Ke Mentoring #390

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

Comments

Projects
None yet
1 participant
@wildanm
Member

wildanm commented Aug 25, 2016

Yang bisa mengupload materi mentoring :

  1. Mentor
  2. SBA/TU

Siswa hanya dapat melihat

@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Oct 14, 2016

Member

Jalankan SQL berikut :

CREATE TABLE emateri_mentoring
(
    id INTEGER  NOT NULL AUTO_INCREMENT,
    kd_unit_kerja VARCHAR(50)  NOT NULL,
    keterangan VARCHAR(255)  NOT NULL,
    tahun VARCHAR(4)  NOT NULL,
    semester INTEGER  NOT NULL,
    bulan INTEGER(2)  NOT NULL,
    minggu INTEGER(1)  NOT NULL,
    materi VARCHAR(255)  NOT NULL,
    nip_mentor VARCHAR(20)  NOT NULL,
    created_at DATETIME,
    updated_at DATETIME,
    PRIMARY KEY (id),
    INDEX emateri_mentoring_FI_1 (kd_unit_kerja),
    CONSTRAINT emateri_mentoring_FK_1
        FOREIGN KEY (kd_unit_kerja)
        REFERENCES kode_unit_kerja (kd_unit_kerja)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT,
    INDEX emateri_mentoring_FI_2 (nip_mentor),
    CONSTRAINT emateri_mentoring_FK_2
        FOREIGN KEY (nip_mentor)
        REFERENCES pegawai (nip)
        ON UPDATE CASCADE
)Engine=InnoDB DEFAULT CHARSET=latin1;
Member

wildanm commented Oct 14, 2016

Jalankan SQL berikut :

CREATE TABLE emateri_mentoring
(
    id INTEGER  NOT NULL AUTO_INCREMENT,
    kd_unit_kerja VARCHAR(50)  NOT NULL,
    keterangan VARCHAR(255)  NOT NULL,
    tahun VARCHAR(4)  NOT NULL,
    semester INTEGER  NOT NULL,
    bulan INTEGER(2)  NOT NULL,
    minggu INTEGER(1)  NOT NULL,
    materi VARCHAR(255)  NOT NULL,
    nip_mentor VARCHAR(20)  NOT NULL,
    created_at DATETIME,
    updated_at DATETIME,
    PRIMARY KEY (id),
    INDEX emateri_mentoring_FI_1 (kd_unit_kerja),
    CONSTRAINT emateri_mentoring_FK_1
        FOREIGN KEY (kd_unit_kerja)
        REFERENCES kode_unit_kerja (kd_unit_kerja)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT,
    INDEX emateri_mentoring_FI_2 (nip_mentor),
    CONSTRAINT emateri_mentoring_FK_2
        FOREIGN KEY (nip_mentor)
        REFERENCES pegawai (nip)
        ON UPDATE CASCADE
)Engine=InnoDB DEFAULT CHARSET=latin1;
@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Oct 19, 2016

Member

Done in 5396521 (bitbucket)

Member

wildanm commented Oct 19, 2016

Done in 5396521 (bitbucket)

@wildanm wildanm closed this Oct 19, 2016

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