database.dbml

Table user {
    id serial [not null, primary key]
    created_at timestamptz [default: `CURRENT_TIMESTAMP`]
    modified_at timestamptz [default: `CURRENT_TIMESTAMP`]
    email varchar(255) [not null, unique]
    password varchar(1000) [not null]
    disabled bool [not null, default: false]
    name varchar(255) [not null, default: 'John Doe']
    -- The User model, This is the table used to store auth credentials
    note: 'The User model, This is the table used to store auth credentials'
}

Table comments {
    id serial [not null, primary key]
    created_at timestamptz [default: `CURRENT_TIMESTAMP`]
    modified_at timestamptz [default: `CURRENT_TIMESTAMP`]
    position_id int
    url_id int [not null]
    comment text [not null]
    status bool [not null, default: true]
    anchor_text text [not null]
    user_id_id int [not null, ref: > user.id, on delete: CASCADE]
}

Table positionaldata {
    id serial [not null, primary key]
    created_at timestamptz [default: `CURRENT_TIMESTAMP`]
    modified_at timestamptz [default: `CURRENT_TIMESTAMP`]
    identifier jsonb [not null]
    url_id int [not null]
}

Table urls {
    id serial [not null, primary key]
    created_at timestamptz [default: `CURRENT_TIMESTAMP`]
    modified_at timestamptz [default: `CURRENT_TIMESTAMP`]
    link text [not null]
}