jerguero-rs/db/schema.sql

15 lines
347 B
MySQL
Raw Permalink Normal View History

2024-02-25 23:29:46 +00:00
-- PostgreSQL schema for the system
2024-08-10 21:50:09 +00:00
create table person(
person_id serial primary key,
2024-08-11 00:28:10 +00:00
person_email varchar(100) not null,
person_password varchar(100) not null
);
-- Sessions
create table session(
session_id serial primary key,
session_person_id integer not null,
session_created_at timestamp with time zone not null
2024-08-10 21:50:09 +00:00
);