over 1 year ago

ERD (Entity Relationship Diagram) + DDL SQL code

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------

-- Schema elba

-- -----------------------------------------------------

-- Schema elba

-- -----------------------------------------------------

CREATE SCHEMA IF NOT EXISTS `elba` DEFAULT CHARACTER SET utf8 ;

USE `elba` ;

-- -----------------------------------------------------

-- Table `elba`.`usergroup`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `elba`.`usergroup` (

`id_usergroup` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(45) NOT NULL,

PRIMARY KEY (`id_usergroup`),

UNIQUE INDEX `id_usergroup_UNIQUE` (`id_usergroup` ASC) VISIBLE)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `elba`.`user`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `elba`.`user`…

almost 2 years ago

IMPORTANT - Preparing for the In-Person Day

IMPORTANT - Only teams and participants that attend the in-person day will be eligible to win the event, so it is important that you and your team attend the in-person day of the event.

This is a checklist of items to prepare for the in-Person Day of the Fitch London Codeathon 2024.

For participants who have not already done so, please confirm that you will be attending the in-person day of the event on the 13th of September 2024 at:
FITCH RATINGS LTD. 30 North Colonnade, Canary Wharf, London, E14 5GN, UK
Please submit your name and the names…

almost 2 years ago

Discord will be the medium of communication

We will be using Discord as the medium of communication between teams and mentors. Please sign-up to Discord. The joining link for the Discord channel will be given to participants on the in-person day on the 13th of September 2024.

almost 2 years ago

2nd REMINDER - Confirmation of In-Person Attendance, Location & Team Information

This is to remind all participants, individuals and teams alike to confirm the below, if they have not already done so:

Provide the size of your team, ideally we would like to teams to comprise of a maximum of 5 participants.
Confirm that you and all members of your team are based in London in the U.K. and will attend the event in-person on the 13th of September 2024.
Provide T-shirt sizes and dietary requirements for all of your team members.
Individuals who are looking for a team, please connect with other participants who are also looking for a team…

almost 2 years ago

REMINDER - Confirmation of In-Person Attendance, Location & Team Information

This is to remind all participants, individuals and teams alike to confirm the below:

Provide the size of your team, ideally we would like to teams to comprise of a maximum of 5 participants.
Confirm that you and all members of your team are based in London in the U.K. and will attend the event in-person on the 13th of September 2024.
Provide T-shirt sizes and dietary requirements for all of your team members.
Individuals who are looking for a team, please connect with other participants who are also looking for a team to ensure you can form a team…

almost 2 years ago

Confirmation of In-Person Attendance, Location & Team Information

This is to remind all participants, individuals and teams alike to confirm the below:

Provide the size of your team, ideally we would like to teams to comprise of a maximum of 5 participants.
Confirm that you and all members of your team are based in London in the U.K. and will attend the event in-person on the 13th of September 2024.
Provide T-shirt sizes and dietary requirements for all of your team members.

Please send the confirmation of the above to the email at: fitch-code4good-london@thefitchgroup.com