organisations

1501 rows


Description

Stores Organisation data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
name VARCHAR 100 null
website VARCHAR 100 √ null
mobile VARCHAR 30 √ null
email VARCHAR 125 √ null
address VARCHAR 512 √ null
city VARCHAR 127 √ null
pincode VARCHAR 15 √ null
state_id VARCHAR 36 √ null
district_id VARCHAR 36 √ null
tenant_id VARCHAR 36 null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
status BIT 1 √ 1

0:Inactive,1:Active
created_by VARCHAR 36 √ null
deleted_at TIMESTAMP 19 √ null
old_data_id INT 10 √ null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
is_approved TINYINT 3 √ 1

1:Approved,0:Not Approved
approved_by VARCHAR 36 √ null
approval_group VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
created_by Performance Asc created_by
deleted_by Performance Asc deleted_by
district_id Performance Asc district_id
name Performance Asc name
organisations_id_IDX Performance Asc id
state_id Performance Asc state_id
status Performance Asc status
tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation