Reference

Reference Database

Database

OtherEvergreenPublic

Schema

Table: lists

  • id (integer): Primary key
  • title (character varying): Title of the list
  • description (text): Description of the list
  • slug (text) URL-friendly identifier for the list
  • created_at (timestamp without time zone): When the list was created

Table: links

  • id (integer): Primary key
  • title (character varying): Title of the link
  • description (text): Description of the link
  • url (character varying): URL of the link
  • image (character varying): Image URL associated with the link
  • list_id (integer): Foreign key referencing the lists table
  • created_at (timestamp without time zone): When the link was created

This schema allows you to create lists of links, where each list has a unique slug that can be used in a URL, and each link belongs to a specific list through the list_id foreign key relationship.

DATABASE_URL="mysql://johndoe:randompassword@localhost:3306/mydb"
DATABASE_URL="postgresql://johndoe:randompassword@localhost:5432/mydb?schema=public"
DATABASE_URL="sqlserver://localhost:1433;database=mydb;user=sa;password=r@ndomP@$$w0rd;trustServerCertificate=true"

DATABASE_URL="sqlserver://vticonsulting.database.windows.net:1433;database=vticonsulting;user=vtolbert@vticonsulting;password=sekure1zQ!;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30"

# Dev
Server=(localdb)\\MSSQLLocalDB;
Database=ExemplarCore;
Trusted_Connection=True;
MultipleActiveResultSets=true;

# QA
Server=tcp:han-sql-dev.database.windows.net,1433;
Initial Catalog=ExemplarCore;
Persist Security Info=False;
User ID=iasa;
Password=Innovative123!;
MultipleActiveResultSets=True;
Encrypt=True;
TrustServerCertificate=False;
Connection Timeout=30;

# Prod
Server=tcp:han-sql-prod-east.database.windows.net,1433;
Initial Catalog=ExemplarCore;
Persist Security Info=False;
User ID=hccsqladmin;
Password=Htu849rif%#ja^#a;
MultipleActiveResultSets=True;
Encrypt=True;
TrustServerCertificate=False;
Connection Timeout=30;