datamodel.prisma

type User {
	id: ID! @id
	username: String! @unique
	password: String!
	role: Int! @default(value: 2)
	active: Boolean! @default(value: true)
	profile: Profile
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Profile {
	id: ID! @id
	oldId: ID! @unique
    fullName: String!
	gender: Boolean!
	email: String
	facebookId: String
	phoneNumber: String
	birthday: DateTime
	joinDate: DateTime
	dayOfBirth: Int
	monthOfBirth: Int
	yearOfBirth: Int
	address: Address
	hometown: Province
	memberType: MemberType
	group: Group @relation(link: "TABLE", name: "GroupMembers")
	leader: Group @relation(link: "TABLE", name: "GroupLeader")
	attendances: [ActivityAttendance] @relation(name: "ProfileAttendance")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type MemberType {
	id: ID! @id
	name: String! @unique
	profiles: [Profile!]
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Address {
	id: ID! @id
	no: String
	street: String
	commune: Commune
	district: District
	province: Province
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Commune {
	id: ID! @id
	name: String!
	district: District! @relation(name: "CommuneDistrictRef")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type District {
	id: ID! @id
	name: String!
	communes: [Commune!] @relation(name: "CommuneDistrictRef")
	province: Province! @relation(name: "DistrictProvinceRef")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Province {
	id: ID! @id
	name: String!
	districts: [District!] @relation(name: "DistrictProvinceRef")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Group {
	id: ID! @id
	name: String!
	members: [Profile] @relation(name: "GroupMembers")
	leader: Profile @relation(name: "GroupLeader")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type ActivityType {
	id: ID! @id
	name: String!
	schedules: [ActivitySchedule] @relation(name: "ActivitySchedule")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type ActivitySchedule {
	id: ID! @id
	start: DateTime!
	end: DateTime!
	activity: ActivityType! @relation(name: "ActivitySchedule")
	attendances: [ActivityAttendance] @relation(name: "ScheduleAttendance")
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type ActivityAttendance {
	id: ID! @id
	schedule: ActivitySchedule! @relation(name: "ScheduleAttendance")
	member: Profile! @relation(name: "ProfileAttendance")
	presence: Boolean!
	updatedAt: DateTime! @updatedAt
	createdAt: DateTime! @createdAt
}

type Language {
    id: ID! @id
    code: String! @unique
    name: String!
    translation: [Translation!] @relation(name: "TranslationLanguage")
}

type Translation {
    id: ID! @id
    text: String!
    language: Language @relation(link: TABLE, name: "TranslationLanguage")
    localization: Localization @relation(link: TABLE, name: "TranslationLocalization")
}

type Localization {
    id: ID! @id
    key: String! @unique
    translations: [Translation!] @relation(name: "TranslationLocalization")
}