88
Tables (7)
User_Idol
- user_id — VARCHAR(255) — Primary key — NOT NULL
- idol_id — VARCHAR(255) — Primary key — NOT NULL
- created_at — TIMESTAMP
artist_members
- artist_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Primary key — NOT NULL
- joined_at — DATE
- left_at — DATE
artists
- Key — Primary key — NOT NULL
- id — BIGINT
- name — VARCHAR(120) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- agency — VARCHAR(120)
- gender — VARCHAR(10)
- debut_date — DATE
- photo_url — TEXT
- created_at — TIMESTAMP — NOT NULL
credit_transactions
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- amount — BIGINT — NOT NULL
- balance_after — BIGINT — NOT NULL
- ref_table — VARCHAR(50)
- ref_id — BIGINT
- provider — VARCHAR(50)
- status — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
user_favorites
- user_id — BIGINT — NOT NULL
- artist_id — BIGINT — NOT NULL
users
- user_id (id) — varchar(200) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- Field
- Field2
- Field3
- Field4
wallets
- user_id — BIGINT
- balance_credits — BIGINT — NOT NULL
- updated_at — TIMESTAMP — NOT NULL