meetogether

Tables (9)

account

  • idf_account — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • idf_job_title — bigint(20) — Foreign key → job_title.idf_job_title
  • idf_department — bigint(20) — Foreign key → department.idf_department — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(30)
  • gender — char(1)
  • age — int(11)
  • country — varchar(2)
  • image — varchar(255)
  • user_role — varchar(20)
  • date_updated — datetime
  • date_created — datetime

company

  • idf_company — bigint(20) — Primary key — NOT NULL
  • name — varchar(20)
  • address — varchar(255)
  • enabled — char(1)
  • image — varchar(255)
  • date_updated — datetime
  • date_created — datetime

department

  • idf_department — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • name — varchar(30)
  • date_updated — datetime
  • date_created — datetime

invitation

  • idf_reservation — bigint(20) — Foreign key → reservation.idf_reservation — NOT NULL
  • idf_account — bigint(20) — Foreign key → account.idf_account — NOT NULL
  • attended — char(1)

job_title

  • idf_job_title — bigint(20) — Primary key
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • rank — int(10)
  • name — varchar(30)
  • date_updated — datetime
  • date_created — datetime

notice

  • idf_notice — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • idf_account — bigint(20) — Foreign key → account.idf_account — NOT NULL
  • title — varchar(255)
  • category — varchar(20)
  • content — text
  • view_count — bigint(20)
  • date_updated — datetime
  • date_created — datetime

reservation

  • idf_reservation — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • idf_account — bigint(20) — Foreign key → account.idf_account — NOT NULL
  • name — varchar(100)
  • date_start — datetime
  • date_finish — datetime
  • date_updated — datetime
  • date_created — datetime

space

  • idf_space — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • idf_space_category — bigint(20) — Foreign key → space_category.idf_space_category — NOT NULL
  • name — varchar(20)
  • capacity — bigint(20)
  • spot — varchar(100)
  • image — varchar(255)
  • description — varchar(255)
  • date_updated — datetime
  • date_created — datetime

space_category

  • idf_space_category — bigint(20) — Primary key — NOT NULL
  • idf_company — bigint(20) — Foreign key → company.idf_company — NOT NULL
  • name — varchar(50)
  • date_updated — datetime
  • date_created — datetime