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