---
detect_relations: true
options:
  collation: latin1_swedish_ci
  charset: latin1
  type: InnoDB

setting:
  tableName: settings
  columns:
    idsettings:
      type: integer(4)
      primary: true
      notnull: true
    name:
      type: string(255)
      unique: true
    value:
      type: string(255)
  options:
    charset: latin1
    collate: latin1_swedish_ci
    type: InnoDB

user:
  tableName: users
  columns:
    idusers:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    email:
      type: string(255)
      unique: true
    password:
      type: string(255)
    reg_ip:
      type: string(45)
    last_ip:
      type: string(45)
    last_login:
      type: timestamp
    usergroup:
      type: integer(4)
  relations:
    usergroup:
      class: group
      local: usergroup
      foreign: idgroups
      foreignAlias: users
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB

group:
  tableName: groups
  columns:
    idgroups:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
    description:
      type: string(255)
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB

userprofile:
  tableName: userprofiles
  columns:
    idprofiles:
      type: integer(4)
      unique: true
      notnull: true
    firstname:
      type: string(45)
    lastname:
      type: string(45)
    dob:
      type: date
    phone:
      type: string(45)
    college:
      type: string(45)
    city:
      type: string(45)
    pincode:
      type: string(45)
    branch:
      type: integer(4)
    year:
      type: enum
      values: ['I','II','III','IV']
    semester:
      type: enum
      values: ['NA','I','II']
    title:
      type: string(45)
    node:
      type: enum
      values: ['Anantapur','Hyderabad','Kakinada']
  relations:
    idprofile:
      class: user
      local: idprofiles
      foreign: idusers
      foreignAlias: userprofiles
      onDelete: cascade
      onUpdate: cascade
    branch:
      class: branch
      local: branch
      foreign: idbranches
      foreignAlias: userprofiles
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB

uploadCategory:
  tableName: upload_categories
  columns:
    idupload_categories:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
    description:
      type: string(45)
  options:
    charset: latin1
    collate: latin1_swedish_ci
    type: InnoDB

upload:
  tableName: uploads
  columns:
    iduploads:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    owner:
      type: integer(4)
    name:
      type: string(45)
    description:
      type: string(45)
    category:
      type: integer(4)
    branch:
      type: integer(4)
    year:
      type: enum
      values: ['I','II','III','IV']
    semester:
      type: enum
      values: ['NA','II','III','IV']
    node:
      type: enum
      values: ['Anantapur','Hyderabad','Kakinada']
    type:
      type: enum
      values: ['foreign','local']
    upload_link:
      type: string(45)
  relations:
    owner:
      class: user
      local: owner
      foreign: idusers
      foreignAlias: uploads
    category:
      class: uploadCategory
      local: category
      foreign: idupload_categories
      foreignAlias: uploads
    branch:
      class: branch
      local: branch
      foreign: idbranches
      foreignAlias: uploads
  options:
    charset: latin1
    collate: latin1_swedish_ci
    type: InnoDB

branch:
  tableName: branches
  columns:
    idbranches:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
    designation:
      type: string(45)
      unique: true
  options:
    charset: latin1
    collate: latin1_swedish_ci
    type: InnoDB

branch:
  tableName: branches
  columns:
    idbranches:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
      default: null
    designation:
      type: string(45)
      unique: true
      default: null
  options:
    charset: latin1
    type: InnoDB

group:
  tableName: groups
  columns:
    idgroups:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
      default: null
    description:
      type: string(255)
      default: null
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB

uploadCategory:
  tableName: upload_categories
  columns:
    idupload_categories:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(45)
      unique: true
      default: null
    description:
      type: string(45)
      default: null
  options:
    charset: latin1
    type: InnoDB

upload:
  tableName: uploads
  columns:
    iduploads:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    owner:
      type: integer(4)
      default: null
    name:
      type: string(45)
      default: null
    description:
      type: string(45)
      default: null
    category:
      type: integer(4)
      default: null
    branch:
      type: integer(4)
      default: null
    year:
      type: string(255)
      default: null
    semester:
      type: string(255)
      default: null
    node:
      type: string(255)
      default: null
    type:
      type: string(255)
      default: null
    upload_link:
      type: string(45)
      default: null
  relations:
    category:
      class: uploadCategory
      local: category
      foreign: idupload_categories
      foreignAlias: uploads
  indexes:
    owner_idx:
      fields: [owner]
    category_idx:
      fields: [category]
    branch_idx:
      fields: [branch]
  options:
    charset: latin1
    type: InnoDB

userprofile:
  tableName: userprofiles
  columns:
    id:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    idprofiles:
      type: integer(4)
      unique: true
      notnull: true
    firstname:
      type: string(45)
      default: null
    lastname:
      type: string(45)
      default: null
    phone:
      type: string(45)
      default: null
    city:
      type: string(125)
      default: null
    pincode:
      type: string(45)
      default: null
    college:
      type: string(45)
      default: null
    year:
      type: string(255)
      default: null
    semester:
      type: string(255)
      default: null
    rno:
      type: string(15)
      default: null
    branch:
      type: integer(4)
      default: null
    title:
      type: string(45)
      default: null
    node:
      type: string(255)
      default: null
    usergroup:
      type: integer(4)
      default: 1
  relations:
    idprofile:
      class: user
      local: idprofiles
      foreign: idusers
      foreignAlias: userprofiles
      onDelete: cascade
      onUpdate: cascade
    usergroup:
      class: group
      local: usergroup
      foreign: idgroups
      foreignAlias: userprofiles
      onDelete: set null
      onUpdate: cascade
    branch:
      class: branch
      local: branch
      foreign: idbranches
      foreignAlias: userprofiles
      onDelete: set null
      onUpdate: cascade
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB

user:
  tableName: users
  columns:
    idusers:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    email:
      type: string(255)
      unique: true
      default: null
    password:
      type: string(255)
      default: null
    reg_ip:
      type: string(45)
      default: null
    last_ip:
      type: string(45)
      default: null
    created:
      type: timestamp
      notnull: true
    last_login:
      type: timestamp
      default: null
  options:
    charset: utf8
    collate: utf8_unicode_ci
    type: InnoDB