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