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