example/output/project_mooc.json
{
"Name": "project_mooc",
"Tables": [
{
"Name": "anunturi_angajare",
"Fields": [
{
"Id": "id",
"Type": "INT",
"Length": 11,
"Null": false,
"Default": 0,
"Comment": null,
"Autoincrement": true,
"Values": []
},
{
"Id": "companieID",
"Type": "INT",
"Length": 11,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "denumire",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "pozitii",
"Type": "INT",
"Length": 3,
"Null": true,
"Default": 1,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "program_lucru",
"Type": "ENUM",
"Length": null,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "durata_contract",
"Type": "ENUM",
"Length": null,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "descriere",
"Type": "VARCHAR",
"Length": 5000,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "profil_scoala_primara",
"Type": "INT",
"Length": 1,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "profil_scoala_profesionala",
"Type": "INT",
"Length": 1,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "profil_liceu",
"Type": "INT",
"Length": 1,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "profil_facultate",
"Type": "INT",
"Length": 1,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "profil_postuniversitar",
"Type": "INT",
"Length": 1,
"Null": true,
"Default": 0,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "cerinte",
"Type": "VARCHAR",
"Length": 5000,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "avangaje_oferite",
"Type": "VARCHAR",
"Length": 5000,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "persoanacontact_nume",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": "-Fullname-",
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "persoanacontact_telefon",
"Type": "VARCHAR",
"Length": 30,
"Null": true,
"Default": "555-000-222",
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "persoanacontact_adresa_localitate",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "persoanacontact_adresa_strada",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "persoanacontact_adresa_nr",
"Type": "VARCHAR",
"Length": 20,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "data_angajare",
"Type": "DATE",
"Length": null,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "data_expirare",
"Type": "DATE",
"Length": null,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "created_at",
"Type": "TIMESTAMP",
"Length": null,
"Null": false,
"Default": "CURRENT_TIMESTAMP",
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "updated_at",
"Type": "TIMESTAMP",
"Length": null,
"Null": false,
"Default": "0000-00-00 00:00:00",
"Comment": null,
"Autoincrement": false,
"Values": []
}
],
"Keys": [
{
"Column": "id"
},
{
"Label": "companieID",
"Columns": [
"companieID"
]
},
{
"Label": "ProfilEducatie",
"Columns": [
"profil_scoala_primara",
"profil_scoala_profesionala",
"profil_liceu",
"profil_facultate",
"profil_postuniversitar"
]
},
{
"Label": "pozitii",
"Columns": [
"pozitii"
]
}
]
},
{
"Name": "companii",
"Fields": [
{
"Id": "id",
"Type": "INT",
"Length": 11,
"Null": false,
"Default": 0,
"Comment": null,
"Autoincrement": true,
"Values": []
},
{
"Id": "nume",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "url",
"Type": "VARCHAR",
"Length": 100,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "domeniu",
"Type": "VARCHAR",
"Length": 100,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "email",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "telefon",
"Type": "VARCHAR",
"Length": 100,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "judet",
"Type": "VARCHAR",
"Length": 100,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "localitate",
"Type": "VARCHAR",
"Length": 100,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "strada",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "nr",
"Type": "VARCHAR",
"Length": 20,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "reprezentant",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "username",
"Type": "VARCHAR",
"Length": 255,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "parola",
"Type": "VARCHAR",
"Length": 60,
"Null": true,
"Default": null,
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "created_at",
"Type": "TIMESTAMP",
"Length": null,
"Null": false,
"Default": "CURRENT_TIMESTAMP",
"Comment": null,
"Autoincrement": false,
"Values": []
},
{
"Id": "updated_at",
"Type": "TIMESTAMP",
"Length": null,
"Null": false,
"Default": "0000-00-00 00:00:00",
"Comment": null,
"Autoincrement": false,
"Values": []
}
],
"Keys": [
{
"Column": "id"
}
]
}
]
}