admin Schema Description

Documentation Updated: 2024-10-21

• account_services
• accounts
• business_units
• companies
• project_companies
• project_products
• project_roles
• project_services
• project_user_companies
• project_user_products
• project_user_roles
• project_user_services
• project_users
• projects
• roles
• users

account_services

Service List for the Account

ordinal_position	column_name	data_type	constraints	notes
1	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
2	service	enum: string	Possible Values: documentManagement projectManagement costManagement designCollaboration fieldManagement modelCoordination field glue plan insight	BIM 360 Service

accounts

This is a list of accounts in BIM 360. For individual customer exports, this table will only include the single customer's information.

ordinal_position	column_name	data_type	constraints	notes
1	bim360_account_id	string: UUID		Account Identifier
2	display_name	string	Max length: 255	Display name of the account
3	start_date	timestamp: SQL		Start of the account availability
4	end_date	timestamp: SQL		End of the account availability

business_units

Business units for use in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	id	string: UUID		ID of the Business Unit
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	parent_id	string: UUID		Parent ID of the Business Unit
4	name	string	Max length: 255	Name of the Business Unit
5	description	string	Max length: 255	Description for the Business Unit

companies

Company organizations for use in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	id	string: UUID		Company ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	name	string	Max length: 255	Name of the company
4	trade	enum: string	Max length: 255	Trade of the company
5	category	string	Max length: 255	Category for the company
6	address_line1	string	Max length: 255	Company specified address
7	address_line2	string	Max length: 255	Company specified address
8	city	string	Max length: 255	City for the Company address
9	state_or_province	string	Max length: 255	State for the Company address
10	postal_code	string	Max length: 255	Postal code for the address
11	country	string	Max length: 255	Country of the address
12	phone	string	Max length: 255	Phone for the company
13	website_url	string	Max length: 255	Web site for the company
14	description	string	Max length: 255	Description of the company
15	erp_id	string	Max length: 255	ERP Id
16	tax_id	string	Max length: 255	Tax ID
17	status	enum: string	Possible Values: deleted active	Status of the company
18	created_at	timestamp: SQL		Date company created
19	project_size	number		Size of project
20	user_size	number		User size of project
21	custom_properties	string	Max length: 255	Customer defined properties

project_companies

The company list for projects in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	project_id	string: UUID		Project ID
2	company_id	string: UUID		The company ID for the company that is a part of the project
3	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
4	company_oxygen_id	string		Oxygen ID for the company

project_products

The Product List for the Project

ordinal_position	column_name	data_type	constraints	notes
1	bim360_project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	product_key	enum: string	Possible Values: autoSpecs build buildingConnected capitalPlanning cost designCollaboration docs financials insight modelCoordination projectAdministration takeoff	Bim360/Acc Product
4	status	enum: string	Possible Values: active activating inactive activationFailed deactivationFailed deactivating	Status of the product
5	created_at	timestamp: SQL		Date/time service was added

project_roles

The project roles for projects in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
2	bim360_project_id	string: UUID		Project ID
3	role_oxygen_id	string		Oxygen ID for the role
4	name	string		Name for the role
5	status	enum: string	Possible Values: active inactive	Status of the role

project_services

The Service List for the Account

ordinal_position	column_name	data_type	constraints	notes
1	project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	service	enum: string	Possible Values: documentManagement projectManagement costManagement designCollaboration fieldManagement modelCoordination field glue plan insight	BIM 360 Service
4	status	enum: string	Possible Values: active inactive archived	Status of the service
5	created_at	timestamp: SQL		Date/time service was added

project_user_companies

The company list for projects in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
2	company_oxygen_id	string: UUID		Oxygen ID for the company
3	project_id	string: UUID		Project ID
4	user_id	string: UUID		The user ID for the member of the company

project_user_products

The product list for the users in a particular project

ordinal_position	column_name	data_type	constraints	notes
1	bim360_project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	user_id	string: UUID		The user ID for the member of the project
4	product_key	enum: string	Possible Values: autoSpecs build buildingConnected capitalPlanning cost designCollaboration docs financials insight modelCoordination projectAdministration takeoff	ACC product the user has access to for this project
5	access_level	enum: string	Possible Values: project_user project_admin	The Project access level for the user
6	created_at	timestamp: SQL		Date user added to the product

project_user_roles

The list of roles for the user in a particular project

ordinal_position	column_name	data_type	constraints	notes
1	project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	user_id	string: UUID		The user ID for the member of the project
4	role_id	string: UUID		The role the user has for this particular project
5	created_at	timestamp: SQL		Date user added to project

project_user_services

The service list for the user in a particular project

ordinal_position	column_name	data_type	constraints	notes
1	project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	user_id	string: UUID		The user ID for the member of the project
4	service	enum: string	Possible Values: projectAdministration documentManagement projectManagement costManagement designCollaboration fieldManagement modelCoordination field glue plan insight	BIM 360 Service the user has access to for this project
5	role	enum: string	Possible Values: project_user project_admin	The Project role for the user
6	created_at	timestamp: SQL		Date user added

project_users

The user list for projects

ordinal_position	column_name	data_type	constraints	notes
1	bim360_project_id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	user_id	string: UUID		The user ID for the member of the project
4	status	string	Possible Values: active activating deleted	The user's status for the project
5	company_id	string: UUID		The user's assigned company for the project
6	access_level	string	Possible Values: project_user project_admin	The user's access level for the project
7	created_at	timestamp: SQL		Created date
8	updated_at	timestamp: SQL		Updated date

projects

Projects in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	id	string: UUID		Project ID
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	name	string	Max length: 255	Name of the project
4	start_date	timestamp: SQL		Start date for the project
5	end_date	timestamp: SQL		End date for the project
6	type	string	Possible Values: <userDefinedValue> Convention Center Data Center Hotel / Motel Office Parking Structure / Garage Performing Arts Restaurant Retail Stadium / Arena Theme Park Warehouse (non-manufacturing) Assisted Living / Nursing Home Hospital Medical Laboratory Medical Office OutPatient Surgery Center Court House Dormitory Education Facility Government Building Library Military Facility Museum Prison / Correctional Facility Recreation Building Religious Building Research Facility / Laboratory Multi-Family Housing Single-Family Housing Airport Bridge Canal / Waterway Dams / Flood Control / Reservoirs Harbor / River Development Rail Seaport Streets / Roads / Highways Transportation Building Tunnel Waste Water / Sewers Water Supply Manufacturing / Factory Mining Facility Oil & Gas Plant Power Plant Solar Farm Utilities Wind Farm Demonstration Project Template Project Training Project	Project type definition
7	value	number		Project Value
8	currency	enum: string	Possible Values: USD AUD CAD EUR GBP ALL AZN BYR BRL BGN CNY HRK CZK DKK EEK HKD HUF ISK INR IRR ILS JPY KZT KRW KPW KGS LVL LTL MKD MNT ANG NOK PKR PLN RON RUB SAR RSD SGD ZAR SEK CHF TWD TRL UAH UZS YER PHP NZD MYR THB IDR VND	Value currency
9	status	enum: string	Possible Values: active pending expired archived deleted	Status of the project
10	job_number	string	Max length: 100	Job number of the project
11	address_line1	string	Max length: 255	Address of the project
12	address_line2	string	Max length: 255	Address of the project
13	city	string	Max length: 255	City of the project
14	state_or_province	string	Max length: 255	State of the project
15	postal_code	string	Max length: 255	Postal code for the project
16	country	string	Max length: 255	Country for the project
17	timezone	enum: string	Possible Values: Pacific/Honolulu America/Juneau America/Los_Angeles America/Phoenix America/Denver America/Chicago America/New_York America/Indiana/Indianapolis Pacific/Pago_Pago Pacific/Midway America/Tijuana America/Chihuahua America/Mazatlan America/Guatemala America/Mexico_City America/Monterrey America/Regina America/Bogota America/Lima America/Caracas America/Halifax America/Guyana America/La_Paz America/Santiago America/St_Johns America/Sao_Paulo America/Argentina/Buenos_Aires America/Godthab Atlantic/South_Georgia Atlantic/Azores Atlantic/Cape_Verde Africa/Casablanca Europe/Dublin Europe/Lisbon Europe/London Africa/Monrovia Etc/UTC Europe/Amsterdam Europe/Belgrade Europe/Berlin Europe/Bratislava Europe/Brussels Europe/Budapest Europe/Copenhagen Europe/Ljubljana Europe/Madrid Europe/Paris Europe/Prague Europe/Rome Europe/Sarajevo Europe/Skopje Europe/Stockholm Europe/Vienna Europe/Warsaw Africa/Algiers Europe/Zagreb Europe/Athens Europe/Bucharest Africa/Cairo Africa/Harare Europe/Helsinki Europe/Istanbul Asia/Jerusalem Europe/Kiev Africa/Johannesburg Europe/Riga Europe/Sofia Europe/Tallinn Europe/Vilnius Asia/Baghdad Asia/Kuwait Europe/Minsk Africa/Nairobi Asia/Riyadh Asia/Tehran Asia/Muscat Asia/Baku Europe/Moscow Asia/Tbilisi Asia/Yerevan Asia/Kabul Asia/Karachi Asia/Tashkent Asia/Kolkata Asia/Colombo Asia/Kathmandu Asia/Almaty Asia/Dhaka Asia/Yekaterinburg Asia/Rangoon Asia/Bangkok Asia/Jakarta Asia/Novosibirsk Asia/Shanghai Asia/Chongqing Asia/Hong_Kong Asia/Krasnoyarsk Asia/Kuala_Lumpur Australia/Perth Asia/Singapore Asia/Taipei Asia/Ulaanbaatar Asia/Urumqi Asia/Irkutsk Asia/Tokyo Asia/Seoul Australia/Adelaide Australia/Darwin Australia/Brisbane Australia/Melbourne Pacific/Guam Australia/Hobart Pacific/Port_Moresby Australia/Sydney Asia/Yakutsk Pacific/Noumea Asia/Vladivostok Pacific/Auckland Pacific/Fiji Asia/Kamchatka Asia/Magadan Pacific/Majuro Pacific/Guadalcanal Pacific/Tongatapu Pacific/Apia Pacific/Fakaofo	Timezone for the project
18	construction_type	enum: string	Possible Values: New Construction Renovation	Construction type
19	contract_type	enum: string	Possible Values: Construction Management (CM) at Risk Design-Bid Design-Bid-Build Design-Build-Operate IPD	Contract type for the project
20	business_unit_id	string: UUID		Business Unit ID for the project Foreign Key: Table: business_units Column: id
21	last_sign_in	timestamp: SQL		Last access / sign in for the project
22	created_at	timestamp: SQL		Time project was created
23	acc_project	boolean		Indicator if this is an ACC Project versus a BIM 360 Project
24	latitude	number		Latitude for the project site
25	longitude	number		Longitude for the project site
26	updated_at	timestamp: SQL		Time project was last updated
27	status_reason	string		Reason for the current project status
28	total_member_size	number		Total active members within the project. NOTE: This is not real time data
29	total_company_size	number		Total active companies within the project. NOTE: This is not real time data
30	classification	string	Possible Values: component production sample template	Project Classification

roles

The industry roles for use in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	id	string: UUID		The ID of the Role
2	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
3	name	string	Max length: 255	The Name of the Role
4	status	enum: string	Possible Values: active inactive	Status of the Role

users

Users in BIM 360.

ordinal_position	column_name	data_type	constraints	notes
1	id	string: UUID		The HQ User ID
2	autodesk_id	string	Max length: 255	Autodesk User ID
3	bim360_account_id	string: UUID		BIM 360 HQ Account ID.
4	email	string	Max length: 255	Email address for the user
5	name	string	Max length: 255	Name for the user
6	first_name	string	Max length: 255	First name of the user
7	last_name	string	Max length: 255	Last name of the user
8	address_line1	string	Max length: 255	User specified address
9	address_line2	string	Max length: 255	User specified address
10	city	string	Max length: 255	City for the user address
11	state_or_province	string	Max length: 255	State for the user address
12	postal_code	string	Max length: 255	Postal code for the address
13	country	string	Max length: 255	Country for the user
14	last_sign_in	timestamp: SQL		Last time the user has signed in to BIM 360
15	phone	string	Max length: 255	Phone number for the user
16	job_title	string	Max length: 255	User specified job title
17	access_level_account_admin	boolean		Account Administrator
18	access_level_project_admin	boolean		Indicates the user is a project admin for at least 1 active project
19	access_level_project_member	boolean		Indicates the user is participating in at least 1 active project in which they are not an admin
20	access_level_executive	boolean		Account Executive
21	default_role_id	string: UUID	Max length: 255	ID of the account role to set when adding users to additional projects. For example if this ID is for 'Architect' then by default the user will be set to an 'Architect' role in any projects.
22	default_company_id	string: UUID	Max length: 255	ID of the company ID to set when adding users to additional projects.
23	status	string	Possible Values: active inactive	Current status of a user in the account
24	status_reason	string		Reason for the current user status in the account
25	created_at	timestamp: SQL		Time user was added to the account
26	updated_at	timestamp: SQL		Last time the user record was updated