public.vwbudetails

Description

Business unit details

Table Definition

CREATE VIEW vwbudetails AS (
 SELECT bu.id,
    bu.name,
    bu.updated,
    bu.divisionid AS division_id,
    dd.name AS division_name
   FROM (budetails bu
     LEFT JOIN divisiondetails dd ON (((dd.id)::text = (bu.divisionid)::text)))
)

Columns

Name	Type	Nullable	Comment
id	varchar(50)	true	Primary Key
name	varchar(50)	true	Name
updated	timestamp without time zone	true	Last Updated
division_id	varchar(50)	true	Business Unit Division GUID
division_name	varchar(50)	true	Business Unit Division Name

Referenced Tables

Name	Columns	Comment	Type
public.budetails	4		BASE TABLE
public.divisiondetails	5		BASE TABLE