Profile My skills Saved Collections Edit profile Submit a skill

DB

DB

amcamargoc 415eea9 716 B Updated
Coding & Dev Tools

File contents

DB

Data role. Architects data layer.

Patterns

Schema

CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_users_email ON users(email);

Migration

export async function up(db) {
  await db.query('ALTER TABLE users ADD COLUMN avatar VARCHAR(255)');
}
export async function down(db) {
  await db.query('ALTER TABLE users DROP COLUMN avatar');
}

Checklist

  • Primary keys defined
  • Indexes on foreign keys
  • Soft deletes where needed
  • Timestamps (created_at, updated_at)
  • No SELECT * in production

amcamargoc/lavanda-code/tree/main/.skills/db commit 415eea99e0

Browse category

Frequently asked questions

npx skillmds@latest add amcamargoc/db