projects

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

project_id

serial

10

√

nextval('projects_project_id_seq'::regclass)

modules_test_meta.project_id	modules_testdata_meta_project_id_fkey	R
test_meta.project_id	arbin_schedules_project_id_fk	R

Unique identifier for the project. Auto-incremented upon insertion.

project_name

text

2147483647

√

null

The name of the project.

customer_id

int4

10

√

null

customers.customer_id

projects_customer_id_fkey

R

The customer the project is associated with. References the customer_id in the customers table.

Constraint Name	Type	Sort	Column(s)
projects_pkey	Primary key	Asc	project_id