Readme

Project ini berisi struktur siap pakai. IDE yang digunakan adalah Netbeans. Sesuaikan nama project, artifact dan package. Gunakan fitur Refactor untuk rename. Fitur :

• Springboot + maven
• Side Bar dengan menu
• Menu, user dan role Management
• Theme Selector (dark/light)
• Layout siap pakai
• Session/Security Handler
• Responsive Design (AdminLTE)
• Paging dilakukan di Backend

-- LIST TABLE MENU, ROLE AND USER MANAGEMENT
CREATE TABLE "MMENU" (
    "IDMENU" NUMBER NOT NULL ENABLE,
    "NAME" VARCHAR2(256 BYTE),
    "URL" VARCHAR2(256 BYTE),
    "NAMESPACE" VARCHAR2(256 BYTE),
    "STATUS" VARCHAR2(20 BYTE),
    "CREATEDBY" VARCHAR2(20 BYTE),
    "DATECREATED" DATE,
    "UPDATEDBY" VARCHAR2(20 BYTE),
    "DATEUPDATED" DATE,
    "IDPARENT" NUMBER,
    "IDMENUGROUP" NUMBER,
    "ORDERNO" NUMBER,
    CONSTRAINT "MMENU_PK" PRIMARY KEY ("IDMENU")
);

-- Group : Master, Transaction, Report etc
CREATE TABLE "MMENUGROUP" (
    "IDMENUGROUP" NUMBER NOT NULL ENABLE,
    "NAME" VARCHAR2(256 BYTE),
    "STATUS" VARCHAR2(20 BYTE),
    "ORDERNO" NUMBER,
    CONSTRAINT "MMENUGROUP_PK" PRIMARY KEY ("IDMENUGROUP")
);

CREATE TABLE "MUSER" (
    "IDUSER" NUMBER NOT NULL ENABLE,
    "NIK" NUMBER,
    "STATUS" VARCHAR2(20 BYTE),
    CONSTRAINT "MUSER_PK" PRIMARY KEY ("IDUSER")
);

-- Group : Super Administrator, Administrator etc
CREATE TABLE ""MUSERGROUP" (
    "IDUSERGROUP" NUMBER NOT NULL ENABLE,
    "NAME" VARCHAR2(256 BYTE),
    "STATUS" VARCHAR2(20 BYTE),
    CONSTRAINT "MUSERGROUP_PK" PRIMARY KEY ("IDUSERGROUP")
);

CREATE TABLE "MUSERGROUPMENU" (
    "IDUSERGROUPMENU" NUMBER NOT NULL ENABLE,
    "IDUSERGROUP" NUMBER,
    "IDMENU" NUMBER,
    "STATUS" VARCHAR2(20 BYTE),
    CONSTRAINT "MUSERGROUPMENU_PK" PRIMARY KEY ("IDUSERGROUPMENU")
);

CREATE TABLE "MUSERGROUPMAP" (
    "IDUSERGROUPMAP" NUMBER NOT NULL ENABLE,
    "IDUSER" NUMBER,
    "IDUSERGROUP" NUMBER,
    "STATUS" VARCHAR2(20 BYTE),
    CONSTRAINT "MUSERGROUPMAP_PK" PRIMARY KEY ("IDUSERGROUPMAP")
);