샘플3 S.Box

테이블 (37)

Branch (Untitled11)

  • id (Key) — num — 기본 키 — NOT NULL
  • shopId (Key2) — num — 외래 키 → Shop.id — NOT NULL
  • Shop (Field5) — Shop
  • names (Field) — ShopName[]
  • phoneNumbers (Field14) — str[]
  • prodcuts (Field3) — Product[]
  • address (Field7) — str[]
  • googleMapUrl (Field2) — str
  • longuitude (Field6) — num
  • latitude (Field9) — num
  • isMain (Field4) — bool — NOT NULL
  • createdAt (Field12) — DateTime — NOT NULL
  • updatedAt (Field8) — DateTime — NOT NULL

BranchName (CopyOfUntitled3)

  • id (Key2) — num — 기본 키 — NOT NULL
  • branchId (Key) — num — 외래 키 → Branch.id
  • Branch (Field5) — Branch
  • lang (Field) — str — NOT NULL
  • word (Field2) — str — NOT NULL
  • createdAt (Field3) — DateTime — NOT NULL
  • updatedAt (Field4) — DateTime — NOT NULL

Class (Untitled9)

  • id (Key) — num — 기본 키 — NOT NULL
  • names (Field) — CategoryName[] — NOT NULL
  • tags (Field2) — Tag[]
  • category (Field5) — Category
  • createdAt (Field3) — DateTime — NOT NULL
  • updatedAt (Field4) — DateTime — NOT NULL

ClassName (CopyOfCopyOfUntitled32)

  • id (Key2) — num — 기본 키 — NOT NULL
  • classId (Key) — num — 외래 키 → Class.id
  • Class (Field5) — Class
  • lang (Field) — str — NOT NULL
  • word (Field2) — str — NOT NULL
  • createdAt (Field3) — DateTime — NOT NULL
  • updatedAt (Field4) — DateTime — NOT NULL

Event (Untitled14)

  • id (Key) — num — 기본 키 — NOT NULL
  • images (Field3) — EventImage[]
  • videos (Field4) — EventVideos[]
  • preferrers (Field2) — LikeEvent[]
  • url (Field5) — str
  • dueDate (Field9) — DateTime — NOT NULL
  • bannerImage (Field10) — str — NOT NULL
  • tags (Field11) — Tag[]
  • views (Field12) — View[]
  • isOnList (Field) — bool — NOT NULL
  • title (Field13) — str — NOT NULL
  • onDetailTagId (Field8) — Int[]
  • contentsImages (Field14) — EventContentsImage[]
  • startDate (Field15) — DateTime — NOT NULL
  • createdAt (Field6) — DateTime — NOT NULL
  • updatedAt (Field7) — DateTime — NOT NULL

EventContentImage (CopyOfCopyOfCopyOfCopyOfUntitled42)

  • id (Key2) — num — 기본 키 — NOT NULL
  • eventId (Key) — num — 외래 키 → Event.id
  • Event (Field3) — Event
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

EventImage (CopyOfCopyOfUntitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • eventId (Key) — num — 외래 키 → Event.id
  • Event (Field3) — Event
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

EventVideo (CopyOfCopyOfCopyOfUntitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • eventId (Key) — num — 외래 키 → Event.id
  • Event (Field3) — Event
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL
  • isYoutube (Field6) — bool — NOT NULL

Event_Tag (CopyOfCopyOfUntitled17)

  • eventId (Key) — num — 외래 키 → Event.id — NOT NULL
  • tagId (Key2) — num — 외래 키 → Tag.id — NOT NULL

Like (Untitled12)

  • id (Key) — num — 기본 키 — NOT NULL
  • postId (Key3) — num — 외래 키 → Post.id
  • productId (Key2) — num — 외래 키 → Product.id
  • userId (number) — num — 외래 키 → User.id — NOT NULL
  • eventId (Key4) — num — 외래 키 → Event.id — NOT NULL
  • shopId (Key5) — num — 외래 키 → Shop.id — NOT NULL
  • Post (Field4) — Post
  • Product (Field3) — Product
  • User (Field5) — User — NOT NULL
  • createdAt (Field) — DateTime — NOT NULL
  • updatedAt (Field2) — DateTime — NOT NULL
  • Event (Field6) — Event
  • Shop (Field7) — Shop

Post (Untitled7)

  • id (Key) — num — 기본 키 — NOT NULL
  • shopId (Key2) — num — 외래 키 → Shop.id — NOT NULL
  • Shop (Field13) — Shop
  • text (Field2) — str
  • images (Field6) — PostImage[]
  • preferrers (Field9) — LikeContent[]
  • weeklyRankScore (Field11) — float
  • lifeTimeRankScore (Field17) — float
  • monthlyRankScore (Field16) — float
  • products (Field4) — Product[]
  • tags (Field5) — Tag[]
  • videos (Field12) — PostVideo[]
  • mainProductId (Field14) — num
  • mainProductPrice (Field15) — str
  • views (Field10) — View[]
  • priority (Field18) — num
  • onDetailTagId (Field3) — num[]
  • isOnline (Field19) — bool
  • externalLinkClickNum (Field20) — num
  • postExternalLinks (Field21) — PostExternalLink[]
  • weeklyRankScore (Field) — num
  • monthlyRankScore (Field22) — num
  • lifeTimeRankScore (Field23) — num
  • createdAt (Field7) — DateTime — NOT NULL
  • updatedAt (Field8) — DateTime — NOT NULL

PostExternalLink (CopyOfCopyOfCopyOfUntitled422)

  • id (Key2) — num — 기본 키 — NOT NULL
  • postId (Key) — num — 외래 키 → Post.id
  • Post (Field3) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • linkType (Field6) — LinkType — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

PostImage (CopyOfUntitled42)

  • id (Key2) — num — 기본 키 — NOT NULL
  • postId (Key) — num — 외래 키 → Post.id
  • Post (Field3) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

PostVideo (CopyOfCopyOfUntitled42)

  • id (Key2) — num — 기본 키 — NOT NULL
  • postId (Key) — num — 외래 키 → Post.id
  • Post (Field3) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL
  • isYoutube (Field6) — bool

Post_Product (Untitled10)

  • postId (Key) — num — 외래 키 → Post.id — NOT NULL
  • productId (Key2) — num — 외래 키 → Product.id — NOT NULL

Post_Tag (CopyOfUntitled10)

  • postId (Key) — num — 외래 키 → Post.id — NOT NULL
  • tagId (Key2) — num — 외래 키 → Tag.id — NOT NULL

Product (Untitled2)

  • id (Key) — num — 기본 키 — NOT NULL
  • names (Field) — ProductName[] — NOT NULL
  • images (Field2) — ProductImage[]
  • preferrers (Field5) — LikeContent[]
  • branches (Field6) — Branch[]
  • tags (Field3) — Tag[]
  • posts (Field11) — Post[]
  • discription (Field4) — str
  • instaText (Field8) — str
  • price (Field12) — num
  • externalLinks (Field14) — ProductExternalLink[]
  • videos (Field15) — ProductVideo
  • views (Field7) — View[]
  • priority (Field13) — num
  • createdAt (Field9) — DateTime — NOT NULL
  • updatedAt (Field10) — DateTime — NOT NULL

ProductExternalLink (Untitled16)

  • id (Key) — num — 기본 키 — NOT NULL
  • productId (Key2) — num — 외래 키 → Product.id
  • Product (Field4) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — num — NOT NULL
  • linkType (Field3) — LinkType — NOT NULL
  • createdAt (Field5) — DateTime — NOT NULL
  • updatedAt (Field6) — DateTime — NOT NULL
  • isShown (Field7) — bool — NOT NULL

ProductImage (Untitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • productId (Key) — num — 외래 키 → Product.id
  • Product (Field3) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

ProductName (Untitled3)

  • id (Key2) — num — 기본 키 — NOT NULL
  • productId (Key) — num — 외래 키 → Product.id
  • Product (Field5) — Product
  • lang (Field) — str — NOT NULL
  • word (Field2) — str — NOT NULL
  • createdAt (Field3) — DateTime — NOT NULL
  • updatedAt (Field4) — DateTime — NOT NULL

ProductVideo (CopyOfCopyOfCopyOfUntitled42)

  • id (Key2) — num — 기본 키 — NOT NULL
  • productId (Key) — num — 외래 키 → Product.id
  • Product (Field3) — Product
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • isYoutube (Field6) — bool
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

Product_Branch (Untitled18)

  • branchId (Key) — num — 외래 키 → Branch.id — NOT NULL
  • productId (Key2) — num — 외래 키 → Product.id — NOT NULL

Product_Tag (Untitled6)

  • productId (Key) — num — 외래 키 → Product.id — NOT NULL
  • tagId (Key2) — num — 외래 키 → Tag.id — NOT NULL

SearchTagLog (Untitled20)

  • id (Key) — num — 기본 키 — NOT NULL
  • userId (number) — num — 외래 키 → User.id — NOT NULL
  • tagId (Key2) — num — 외래 키 → Tag.id — NOT NULL
  • Tag (Field3) — Tag
  • User (Field4) — User
  • createdAt (Field5) — DateTime

Settings (Untitled8)

  • id (Key) — num — 기본 키 — NOT NULL
  • mainBubbleTagId (Field) — num[]
  • bestBubbleTagId (Field2) — num[]
  • shopBubbleTagId (Field3) — num[]
  • loadingPostNum (Field4) — num — NOT NULL
  • TodaysStylesPeriod (Field5) — num — NOT NULL
  • bestTotalPostNum (Field6) — num — NOT NULL
  • bestConstA (Field7) — num — NOT NULL
  • bestConstB (Field8) — num — NOT NULL
  • shopConstA (Field9) — num — NOT NULL
  • shopConstB (Field10) — num — NOT NULL
  • shopConstC (Field11) — num — NOT NULL
  • adminEmail (Field12) — str — NOT NULL
  • adminEmailPW (Field13) — str — NOT NULL
  • mainEventBannerId (Field15) — num[]
  • QuestionOption (Field16) — str[]
  • SearchPeriod (Field17) — num
  • createdAt (Field18) — DateTime — NOT NULL
  • updatedAt (Field19) — DateTime — NOT NULL

Shop (Untitled15)

  • id (Key) — num — 기본 키 — NOT NULL
  • names (Field) — str[]
  • branches (Field2) — Branbch[]
  • externalLinks (Field3) — ShopExternalLink[]
  • externalLinkClickNum (Field20) — num
  • logoUrl (Field4) — str
  • description (Field5) — str
  • images (Field6) — ShopImage[]
  • videos (Field7) — ShopVideo[]
  • phoneNumber (Field8) — str[]
  • preferrers (Field9) — User[]
  • tags (Field10) — Tag[]
  • posts (Field11) — Post[]
  • views (Field14) — View[]
  • monthlyRankScore (Field16) — float
  • monthlyRankNum (Field21) — num — NOT NULL
  • priority (Field18) — num
  • onDetailTagId (Field17) — num[]
  • createdAt (Field12) — DateTime — NOT NULL
  • updatedAt (Field13) — DateTime — NOT NULL

ShopExternalLink (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • shopId (Key3) — num — 외래 키 → Shop.id
  • Shop (Field3) — Shop
  • url (Field) — str — NOT NULL
  • linkType (Field6) — LinkType — NOT NULL
  • order (Field2) — str — NOT NULL
  • onBottom (Field7) — bool — NOT NULL
  • isShown (Field8) — bool — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

ShopImage (CopyOfUntitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • shopId (Key) — num — 외래 키 → Shop.id
  • Shop (Field3) — Shop
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

ShopName (CopyOfCopyOfUntitled44)

  • id (Key2) — num — 기본 키 — NOT NULL
  • shopId (Key) — num — 외래 키 → Shop.id
  • Shop (Field3) — Shop
  • lang (Field) — str — NOT NULL
  • word (Field2) — str — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

ShopVideo (CopyOfCopyOfCopyOfCopyOfUntitled4)

  • id (Key2) — num — 기본 키 — NOT NULL
  • shopId (Key3) — num — 외래 키 → Shop.id
  • Shop (Field3) — Shop
  • url (Field) — str — NOT NULL
  • order (Field2) — str — NOT NULL
  • isYoutube (Field6) — bool — NOT NULL
  • createdAt (Field4) — DateTime — NOT NULL
  • updatedAt (Field5) — DateTime — NOT NULL

Shop_Tag (CopyOfUntitled17)

  • shopId (Key) — num — 외래 키 → Shop.id — NOT NULL
  • tagId (Key2) — num — 외래 키 → Tag.id — NOT NULL

Tag (Untitled5)

  • id (Key) — num — 기본 키 — NOT NULL
  • classId (Key2) — num — 외래 키 → Class.id — NOT NULL
  • Class (Field3) — Class — NOT NULL
  • names (Field) — TagName[] — NOT NULL
  • shops (Field4) — Shop[]
  • posts (Field5) — Post[]
  • products (Field2) — Product[]
  • events (Field9) — Event[]
  • category (Field10) — Category
  • tagImage (Field13) — str
  • searchTagLogs (Field14) — SearchTagLog[]
  • isClass (Field15) — bool
  • isRecommendation (Field16) — num
  • createdAt (Field6) — DateTime — NOT NULL
  • updatedAt (Field7) — DateTime — NOT NULL

TagName (CopyOfUntitled32)

  • id (Key2) — num — 기본 키 — NOT NULL
  • tagId (Key) — num — 외래 키 → Tag.id
  • Tag (Field5) — Tag
  • lang (Field) — str — NOT NULL
  • word (Field2) — str — NOT NULL
  • createdAt (Field3) — DateTime — NOT NULL
  • updatedAt (Field4) — DateTime — NOT NULL

User (Untitled)

  • id (number) — num — 기본 키 — NOT NULL
  • likes (Field5) — Like[]
  • views (Field4) — View[]
  • searchTagLogIds (Field3) — SearchTagLog[]
  • createdAt (Field) — DateTime — NOT NULL
  • updatedAt (Field2) — DateTime — NOT NULL

View (Untitled19)

  • id (Key4) — num — 기본 키 — NOT NULL
  • userId (number) — num — 외래 키 → User.id
  • shopId (Key) — num — 외래 키 → Shop.id
  • postId (Key2) — num — 외래 키 → Post.id
  • eventId (Key3) — num — 외래 키 → Event.id
  • productId (Key5) — num — 외래 키 → Product.id
  • User (Field) — User
  • Shop (Field4) — Shop
  • Post (Field2) — Post
  • Event (Field3) — Event
  • createdAt (Field5) — DateTime
  • Product (Field6) — Product

enum Category (Untitled13)

  • Location (Field)
  • ProductClass (Field2)
  • Style (Field3)
  • Price (Field4)
  • Feature (Field5)
  • ShopName (Field6)

enum LinkType (CopyOfUntitled13)

  • Instagram (Field)
  • Facebook (Field2)
  • FacebookMessanger (Field3)
  • YouTube (Field4)
  • TikTok (Field5)
  • Shopee (Field6)
  • Sendo (Field7)
  • LAZADA (Field8)
  • Tiki (Field9)
  • OnlineShop (Field10)