site_sampson


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sampson_code CHAR 3 null
site.sampson_code Implied Constraint R
site_contract_holder.sampson_code Implied Constraint R
test_site_greg.sampson_code Implied Constraint R
v_sites.sampson_code Implied Constraint R
v_stores_all.sampson_code Implied Constraint R
org_id INT 10 √ null
site_org.org_id FK_tbn5muh3wco6dldap0vcd3dh2 R
cam_user_id INT 10 √ null
sys_users.user_id FKB298AA89FABF4A33 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sampson_code
FKB298AA89185FB835 Performance Asc org_id
FKB298AA89FABF4A33 Performance Asc cam_user_id

Relationships

Close relationships within degrees of separation