샘플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)