phantomknight287/saturn

public

The operating system for your freelance business.

saturndrizzle0010_organic_gabe_jones.sql

feat: here comes the money442302e7 months ago8 lines · 649 B

1	CREATE TABLE "timesheet_report_recipients" (
2	"id" text PRIMARY KEY
3	"report_id" text NOT NULL
4	"client_member_id" text NOT NULL
5	);
6	--> statement-breakpoint
7	ALTER TABLE "timesheet_report_recipients" ADD
8	ALTER TABLE "timesheet_report_recipients" ADD

feat: here comes the money442302e7 months ago8 lines · 649 B

1	CREATE TABLE "timesheet_report_recipients" (
2	"id" text PRIMARY KEY
3	"report_id" text NOT NULL
4	"client_member_id" text NOT NULL
5	);
6	--> statement-breakpoint
7	ALTER TABLE "timesheet_report_recipients" ADD
8	ALTER TABLE "timesheet_report_recipients" ADD

NOT NULL

,

CONSTRAINT

"

timesheet_report_recipients_report_id_timesheet_reports_id_fk

"

FOREIGN KEY

(

"

report_id

"

)

REFERENCES

"

public

"

.

"

timesheet_reports

"

(

"

id

"

)

ON DELETE cascade

ON UPDATE

no

action

;

--

> statement-breakpoint

CONSTRAINT

"

timesheet_report_recipients_client_member_id_members_id_fk

"

FOREIGN KEY

(

"

client_member_id

"

)

REFERENCES

"

public

"

.

"

members

"

(

"

id

"

)

ON DELETE cascade

ON UPDATE

no

action

;