A Dataedo alternative — for the data dictionary part

CREATE TABLE clients (
    id        bigserial PRIMARY KEY,
    name      varchar(160) NOT NULL,
    industry  varchar(80)
);
COMMENT ON TABLE clients IS 'Companies we deliver projects for';

CREATE TABLE projects (
    id         bigserial   PRIMARY KEY,
    client_id  bigint      NOT NULL REFERENCES clients(id),
    code       varchar(20) NOT NULL UNIQUE,
    started_on date        NOT NULL,
    closed_on  date
);
COMMENT ON COLUMN projects.code IS 'Short code used in invoices and folders';
COMMENT ON COLUMN projects.closed_on IS 'NULL while the project is active';

CREATE TABLE tasks (
    id          bigserial    PRIMARY KEY,
    project_id  bigint       NOT NULL REFERENCES projects(id),
    title       varchar(200) NOT NULL,
    estimate_h  numeric(6,2),
    done        boolean      NOT NULL DEFAULT false
);

CREATE TABLE timesheet (
    task_id   bigint        NOT NULL REFERENCES tasks(id),
    worked_on date          NOT NULL,
    hours     numeric(4,2)  NOT NULL,
    PRIMARY KEY (task_id, worked_on)
);
COMMENT ON TABLE timesheet IS 'Billable hours; one row per task per day';