음원

테이블 (34)

advertBoughtHistory

  • advertBoughtHistoryId (id) — int — 기본 키 — NOT NULL
  • type — int
  • period — int
  • price — int
  • jump — int
  • usePoint — int
  • name — string
  • mobile — string
  • email — string
  • accumPoint — int
  • payType — int
  • deliveryPrice — int
  • totalPrice — int
  • orderNum — string
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL
  • trackKey (TrackId) — int — 외래 키 → track.trackKey — NOT NULL

album

  • albumKey (id) — int — 기본 키 — NOT NULL
  • albumImage — text
  • albumImageName — text
  • bitRate — varchar(100)
  • sampleRate — varchar(100)
  • filename — text
  • filepath — text
  • musictemKEy (MusictemId) — int — 외래 키 → 뮤직템.musictemKEy — NOT NULL
  • type — int
  • albumTitle — varchar(100)
  • totalStandardPrice — int
  • totalDeluxePrice — int
  • totalPlatinumPrice — int
  • tagId (TagId) — int — 외래 키 → tag.tagId — NOT NULL
  • categoryId (CategoryId) — int — 외래 키 → category.categoryId — NOT NULL
  • isPremium — boolean

albumLike (ablumLike)

  • albumLike (id) — int — 기본 키 — NOT NULL
  • albumKey (AlbumId) — int — 외래 키 → album.albumKey — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

artistemBoughtHistory

  • artistemBoughtHistory (id) — int — 기본 키 — NOT NULL
  • payType — string
  • payPeriod — int
  • cardName — string
  • cardNum — string
  • accountName — varchar(100)
  • price — int
  • importKey — string
  • importKey2 — string
  • contactId (ContactId) — int — 외래 키 → contact.contactId — NOT NULL
  • point — int
  • totalPrice — int
  • orderNum — string

artistemLike

  • artistemLike (id) — int — 기본 키 — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL

artistemReview

  • artistemReview (id) — int — 기본 키 — NOT NULL
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL
  • contactId (ContactId) — int — 외래 키 → contact.contactId — NOT NULL

artwork

  • artworkId (id) — int — 기본 키 — NOT NULL
  • type — int
  • musicType — int
  • price — int
  • title — string
  • filename — text
  • filepath — text
  • termsfilename (termsFilename) — text
  • termsFilepath — text
  • proFilename — text
  • proFilepath — text
  • semiProFilename (semiProFilenmame) — text
  • semiProFilepath — text
  • gender — int
  • proPrice — int
  • semiProPrice — int
  • isOk — boolean
  • downloadCnt — int

artworkBoughtHistory

  • artworkBoughtHistoryId (id) — int — 기본 키 — NOT NULL
  • artworkId (ArtworkId) — int
  • artworkName — stirng
  • artworkTitle — string
  • artworkImage — text
  • artworkType — int
  • name — string
  • mobile — string
  • email — string
  • usePoint — int
  • accumPoint — int
  • payType — string
  • price — int
  • deliveryPoint — int
  • totlalPoint (totalPrice) — int
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

artworkTag

  • artworkTag (id) — int — 기본 키 — NOT NULL
  • artworkId (ArtworkId) — int — 외래 키 → artwork.artworkId — NOT NULL
  • tagId (TagId) — int — 외래 키 → tag.tagId — NOT NULL

artworkTagBoughtHistory

  • artworkTagBoughtHistoryId (id) — int — 기본 키 — NOT NULL
  • value — string
  • artworkBoughtHistoryId (ArtworkBoughtHistoryId) — int — 외래 키 → artworkBoughtHistory.artworkBoughtHistoryId — NOT NULL

cart

  • cartId (id) — int — 기본 키 — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL
  • boughtHistoryId — int

category

  • categoryId (id) — int — 기본 키 — NOT NULL
  • name — text
  • categoryType (CategoryTypeId) — int — 외래 키 → categoryType.categoryType — NOT NULL

categoryArtistem

  • categoryArtistemId (id) — int — 기본 키 — NOT NULL
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL
  • categoryId (CategoryId) — int — 외래 키 → category.categoryId — NOT NULL

categoryType

  • categoryType (id) — int — 기본 키 — NOT NULL
  • value — varchar(100)

contact

  • contactId (id) — int — 기본 키 — NOT NULL
  • endDate — Date
  • price — int
  • content — text
  • filename — text
  • filepath — text
  • terms — boolean
  • cancelReason — text
  • okReason — text
  • productFilename — text
  • productFilepath — text
  • productEmail — varchar(100)
  • productContent — text
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL
  • type — int

country

  • countryId (id) — int — 기본 키 — NOT NULL
  • value — varchar(100)
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL

faq

  • faqId (id) — int — 기본 키 — NOT NULL
  • question — text
  • answer — text
  • faqTypeId (FaqTypeId) — int — 외래 키 → faqType.faqTypeId — NOT NULL

faqType

  • faqTypeId (id) — int — 기본 키 — NOT NULL
  • value — varchar(100)

filmography

  • filmographyId (id) — int — 기본 키 — NOT NULL
  • role — varchar(100)
  • comment — text
  • singerName — varchar(100)
  • singName — varchar(100)
  • filename — text
  • filepath — text
  • albumCoverImage — text
  • albumCoverImageName — text
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL

musictemBoughtHistory

  • musictemBoughtHistory (id) — int — 기본 키 — NOT NULL
  • name — varchar(100)
  • mobile — varchar(100)
  • email — varchar(1000)
  • usePoint — int
  • accumPoint — int
  • payType — string
  • productPrice — int
  • deliveryPrice — int
  • totalPrice — int
  • userId — int

musictemLike

  • musictemLike (id) — int — 기본 키 — NOT NULL
  • musictemKEy (MusictemId) — int — 외래 키 → 뮤직템.musictemKEy — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

musitemReview (musictemReview)

  • musictemReview (id) — int — 기본 키 — NOT NULL
  • nickname — varchar(100)
  • profileImage — text
  • content — text
  • rate — int
  • musictemBoughtHistory (MusictemBoughtHistoryId) — int — 외래 키 → musictemBoughtHistory.musictemBoughtHistory — NOT NULL
  • musitemId (musictemId) — int

notice

  • noticeId (id) — int — 기본 키 — NOT NULL
  • title — text
  • isHit — int
  • filepath — text
  • filename — text

question

  • questionId (id) — int — 기본 키 — NOT NULL
  • name — varchar(100)
  • email — varchar(1000)
  • title — text
  • content — text

seller

  • sellerId (id) — int — 기본 키 — NOT NULL
  • isMusictem — boolean
  • isArtistem — boolean
  • activity — text
  • genre — text
  • filename — text
  • filepath — text
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

tag

  • tagId (id) — int — 기본 키 — NOT NULL
  • value — text
  • tagTypeId (TagTypeId) — int — 외래 키 → tagType.tagTypeId — NOT NULL

tagArtistem

  • tagArtistemId (id) — int — 기본 키 — NOT NULL
  • tagId (TagId) — int — 외래 키 → tag.tagId — NOT NULL
  • artistemKey (ArtistemId) — int — 외래 키 → 아티스템.artistemKey — NOT NULL

tagType

  • tagTypeId (id) — int — 기본 키 — NOT NULL
  • value — text

track

  • trackKey (id) — int — 기본 키 — NOT NULL
  • filename — text
  • filepath — text
  • albumKey (AlbumId) — int — 외래 키 → album.albumKey — NOT NULL
  • isTitle — boolean
  • fileLength — int
  • standardPrice — int
  • deluxePrice — int
  • platinumPrice — int
  • licenseType — int

trackLike

  • trackLike (id) — int — 기본 키 — NOT NULL
  • trackKey (TrackId) — int — 외래 키 → track.trackKey — NOT NULL
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

user(일반) (user)

  • UserId (id) — int — 기본 키 — NOT NULL
  • userId — varchar(100)
  • password — varchar(100)
  • name — varchar(100)
  • nickname — varchar(100)
  • email — varchar(100)
  • mobile — varchar(100)
  • isSms — boolean
  • isKakao — boolean
  • isEmail — boolean
  • isContactKakao — boolean
  • isContactEmail — boolean
  • type — int
  • bankName — string
  • accountNum — string
  • artistemId (ArtistemId) — int
  • musictemId (MusictemId) — int

wishItem

  • wishItemId (id) — int — 기본 키 — NOT NULL
  • productId — int
  • thumbnail — text
  • title — varchar(100)
  • productName — varchar(100)
  • artistName — varchar(100)
  • licenseName — varchar(100)
  • price — int
  • cartId (CartId) — int — 외래 키 → cart.cartId — NOT NULL

뮤직템 (musictem)

  • musictemKEy (id) — int — 기본 키 — NOT NULL
  • artistName — varchar(100)
  • profileImage — text
  • profileImageName — text
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL

아티스템 (artistem)

  • artistemKey (id) — int — 기본 키 — NOT NULL
  • name — varchar(100)
  • companyNum — varchar(100)
  • artistName — varchar(100)
  • artistProfileImage — text
  • artistInfo — varchar(100)
  • question1 — text
  • question2 — text
  • question3 — text
  • question4 — text
  • question5 — text
  • question6 — text
  • question7 — text
  • question8 — text
  • UserId — int — 외래 키 → user(일반).UserId — NOT NULL
  • isVacation — boolean
  • isUpdate — boolean