dama-core

Tables (5)

jobs (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

subscription_categories (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

subscriptions (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → subscription_categories.id — NOT NULL
  • name — VARCHAR
  • image_url (image_urlu) — VARCHAR
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

user_scriptions (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • subscription_id — BIGINT — Foreign key → subscriptions.id — NOT NULL
  • billing_cycle — VARCHAR
  • billing_day — INT
  • price — BIGDECIMAL
  • currency — VARCHAR

users (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • job_id — BIGINT — Foreign key → jobs.id — NOT NULL
  • userId — VARCHAR
  • name — VARCHAR
  • email — VARCHAR
  • password_hash — VARCHAR
  • nickname — VARCHAR
  • birth — DATE
  • age — INT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ