AMATDA
Tables (10)
TB_API_SONG
- SONG_ID — NUMBER — Primary key — NOT NULL
- API_TRACK_ID — VARCHAR2(100) — NOT NULL
- TITLE — NVARCHAR2(200) — NOT NULL
- ARTIST_NAME — NVARCHAR2(200)
- ALBUM_NAME — NVARCHAR2(200)
- DURATION — VARCHAR2(20)
- PREVIEW_URL — VARCHAR2(500)
- COVER_URL — VARCHAR2(500)
- RELEASE_DATE — VARCHAR2(20)
TB_FAV_ARTIST
- FAV_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- API_ARTIST_ID — VARCHAR2(100) — NOT NULL
- CREATED_AT — DATE — NOT NULL
TB_FAV_UNIVERSE
- FAV_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- UNIVERSE_ID — NUMBER — NOT NULL
- CREATED_AT — DATE — NOT NULL
TB_NOTIFICATION
- NOTI_ID — NUMBER — Primary key — NOT NULL
- RECEIVER_ID — NUMBER — NOT NULL
- SENDER_ID — NUMBER
- NOTI_TYPE — VARCHAR2(50) — NOT NULL
- TARGET_ID — NUMBER — NOT NULL
- IS_READ — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL
TB_PLAYLIST
- PLAYLIST_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- NAME — NVARCHAR2(100) — NOT NULL
- IS_MAIN — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL
TB_PLAYLIST_TRACK
- MAP_ID — NUMBER — Primary key — NOT NULL
- PLAYLIST_ID — NUMBER — NOT NULL
- SONG_ID — NUMBER — NOT NULL
- TRACK_ORDER — NUMBER
- ADDED_AT — DATE — NOT NULL
TB_REFRESH_TOKEN
- TOKEN_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- TOKEN_VALUE — VARCHAR2(500) — NOT NULL
- EXPIRATION — DATE — NOT NULL
TB_SHORTS_COMMENT
- COMMENT — PRIMARY — NOT NULL — RIMARY KEY (COMMENT_ID)_ID NUMBER NOT NULL SHORTS_ID NUMBER NOT NUL
- MEMBER_ID — NUMBER — NOT NULL
- CONTENT — NVARCHAR2(1000) — NOT NULL
- IS_DELETED — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE
TB_SHORTS_LIKE
- LIKE_ID — NUMBER — Primary key — NOT NULL
- SHORTS_ID — NUMBER — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- CREATED_AT — DATE — NOT NULL
TB_SOCIAL_LOGIN
- SOCIAL_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- PROVIDER — VARCHAR2(50) — NOT NULL
- PROVIDER_ID — VARCHAR2(255) — NOT NULL
- CREATED_AT — DATE — NOT NULL