ㄴㅇㅁㄹ
Tables (8)
hate
- id — INT — Primary key — NOT NULL
- member_id — INT — NOT NULL
- track_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
layer
- Key — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- instrument_type — VARCHAR(100)
- volume — DECIMAL(5,2)
- created_at — DATETIME
like
- id — INT — Primary key — NOT NULL
- member_id — INT — NOT NULL
- track_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
listen_record
- id — INT — Primary key — NOT NULL
- member_id — INT — NOT NULL
- track_id — VARCHAR(255) — NOT NULL
- listened_at — DATETIME
member
- id — INT — Primary key — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
playlist
- id — INT — Primary key — NOT NULL
- member_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — DATETIME
- updated_at — DATETIME
tag
- id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
track
- id — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- genre — VARCHAR(50)
- duration — INT
- member_id — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME