demographic

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int4

10

√

null

dob

date

13

√

null

general_division

text

2147483647

√

null

age_division

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT u.id,
    u.dob,
        CASE
            WHEN (u.dob IS NULL) THEN 'Adult'::text
            WHEN (age((u.dob)::timestamp with time zone) > '18 years'::interval) THEN 'Adult'::text
            ELSE 'Juvenile'::text
        END AS general_division,
        CASE
            WHEN (u.dob IS NULL) THEN 'No Date of Birth Entered'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '00:00:00'::interval) AND (age((u.dob)::timestamp with time zone) < '6 years'::interval)) THEN 'Child 0-5 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '6 years'::interval) AND (age((u.dob)::timestamp with time zone) < '13 years'::interval)) THEN 'Child 6-12 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '13 years'::interval) AND (age((u.dob)::timestamp with time zone) < '18 years'::interval)) THEN 'Teen 13-17 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '18 years'::interval) AND (age((u.dob)::timestamp with time zone) < '26 years'::interval)) THEN 'Adult 18-25 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '26 years'::interval) AND (age((u.dob)::timestamp with time zone) < '50 years'::interval)) THEN 'Adult 26-49 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '50 years'::interval) AND (age((u.dob)::timestamp with time zone) < '60 years'::interval)) THEN 'Adult 50-59 Years Old'::text
            WHEN ((age((u.dob)::timestamp with time zone) >= '60 years'::interval) AND (age((u.dob)::timestamp with time zone) < '70 years'::interval)) THEN 'Adult 60-69 Years Old'::text
            WHEN (age((u.dob)::timestamp with time zone) >= '70 years'::interval) THEN 'Adult 70+'::text
            ELSE NULL::text
        END AS age_division
   FROM actor.usr u;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views