Future proof calendar/event data structure

[yujonglee]

Existing Resources

Reference

• hyprnote/crates/db-user/src/events_types.rs

  Line 6 in 7b655bd

  pub struct Event {

• hyprnote/crates/db-user/src/calendars_types.rs

  Line 4 in 7b655bd

  pub struct Calendar {

Need Edit

• hyprnote/packages/db/src/schema.ts

  Lines 36 to 49 in 7b655bd

  	export const TABLE_EVENTS = "events";
  	export const events = pgTable(TABLE_EVENTS, {
  	...SHARED,
  	calendar_id: uuid("calendar_id").notNull().references(() => calendars.id, { onDelete: "cascade" }),
  	title: text("title").notNull(),
  	started_at: timestamp("started_at").notNull(),
  	ended_at: timestamp("ended_at").notNull(),
  	});
  	export const TABLE_CALENDARS = "calendars";
  	export const calendars = pgTable(TABLE_CALENDARS, {
  	...SHARED,
  	name: text("name").notNull(),
  	});

• hyprnote/apps/desktop2/src/tinybase/store/persisted.ts

  Lines 140 to 152 in 7b655bd

  	calendars: {
  	user_id: { type: "string" },
  	created_at: { type: "string" },
  	name: { type: "string" },
  	} satisfies InferTinyBaseSchema<typeof calendarSchema>,
  	events: {
  	user_id: { type: "string" },
  	created_at: { type: "string" },
  	calendar_id: { type: "string" },
  	title: { type: "string" },
  	started_at: { type: "string" },
  	ended_at: { type: "string" },
  	} satisfies InferTinyBaseSchema<typeof eventSchema>,

External Resources

• https://docs.airbyte.com/integrations/sources/google-calendar
• https://cal.com/docs/platform/atoms/google-calendar-connect
• https://www.nylas.com
• https://docs.nango.dev/integrations/all/outlook