Bibliotheque de données #1

New Issue

Fred · 2025-03-29T18:23:28+01:00

Fred commented

2025-03-29 18:23:28 +01:00

User :

id String unique
userId String
email String
name String
slug String
organisations UserOnOrganisation[]
comment Comment[]
createdAt DateTime
updatedAt DateTime

Organisation :

id String unique
name String
description String
logo String
type String
tag String
slug String
members UserOnOrganisation[]
events Event[]
albums Album[]
terrain Terrain[]
createdAt DateTime
updatedAt DateTime

Role :

id String unique
name String unique
usersOnOrganisations UserOnOrganisation[]

UserOnOrganisation :

userId String
organisationId String
roleId String

user User relation(fields: [userId], references: [id], onDelete: Cascade)
organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade)
role Role relation(fields: [roleId], references: [id], onDelete: Cascade)

createdAt DateTime
@@id([userId, organisationId, roleId])

Event :

id String unique
name String
description String
date DateTime
location String
organisationId String
organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade)
comments Comment[]
createdAt DateTime
updatedAt DateTime

Comment :

id String unique
content String
userId String
eventId String
user User relation(fields: [userId], references: [id], onDelete: Cascade)
event Event relation(fields: [eventId], references: [id], onDelete: Cascade)
createdAt DateTime

Album :

id String unique
title String
organisationId String
organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade)
photos Photo[]
createdAt DateTime
updatedAt DateTime

Photo :

id String unique
url String
albumId String
album Album relation(fields: [albumId], references: [id], onDelete: Cascade)
createdAt DateTime

Terrain :

id String unique
name String
location String
codePostal Int
ville String
lag String
lng String
slug String
Organisation Organisation? relation(fields: [organisationId], references: [id])
organisationId String

### User : id String unique userId String email String name String slug String organisations UserOnOrganisation[] comment Comment[] createdAt DateTime updatedAt DateTime ------------------------------------------- ### Organisation : id String unique name String description String logo String type String tag String slug String members UserOnOrganisation[] events Event[] albums Album[] terrain Terrain[] createdAt DateTime updatedAt DateTime ------------------------------------------- ### Role : id String unique name String unique usersOnOrganisations UserOnOrganisation[] ------------------------------------------- ### UserOnOrganisation : userId String organisationId String roleId String user User relation(fields: [userId], references: [id], onDelete: Cascade) organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade) role Role relation(fields: [roleId], references: [id], onDelete: Cascade) createdAt DateTime @@id([userId, organisationId, roleId]) ------------------------------------------- ### Event : id String unique name String description String date DateTime location String organisationId String organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade) comments Comment[] createdAt DateTime updatedAt DateTime ------------------------------------------- ### Comment : id String unique content String userId String eventId String user User relation(fields: [userId], references: [id], onDelete: Cascade) event Event relation(fields: [eventId], references: [id], onDelete: Cascade) createdAt DateTime ------------------------------------------- ### Album : id String unique title String organisationId String organisation Organisation relation(fields: [organisationId], references: [id], onDelete: Cascade) photos Photo[] createdAt DateTime updatedAt DateTime ------------------------------------------- ### Photo : id String unique url String albumId String album Album relation(fields: [albumId], references: [id], onDelete: Cascade) createdAt DateTime ------------------------------------------- ### Terrain : id String unique name String location String codePostal Int ville String lag String lng String slug String Organisation Organisation? relation(fields: [organisationId], references: [id]) organisationId String

Sign in to join this conversation.

No Label

No Milestone

No project

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Fred/airsoft-search#1