ARmakers

Tables (48)

TemplateMood (CopyOfUntitled7)

  • Key — Primary key — NOT NULL
  • moodId — Foreign key → Mood.Key — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL

TemplateStyle (CopyOfUntitled6)

  • Key — Primary key — NOT NULL
  • styleId — Foreign key → Style.Key — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL

TemplateTheme (CopyOfUntitled82)

  • id — Primary key — NOT NULL
  • themeId — Foreign key → Theme.Key — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL

TemplateTracker (CopyOfCopyOfUntitled8)

  • id — Primary key — NOT NULL
  • TrackerId — Foreign key → Tracker.Key — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL

ClientSubStatus (Untitled16)

  • id — Primary key — NOT NULL
  • ProjectMainStatusId (id2) — Foreign key → ProjectMainStatus.id — NOT NULL
  • clientStatus (Field)

Creator (creators)

  • Field — Primary key
  • UserId — Foreign key → User.id — NOT NULL
  • link
  • availableTimeStart
  • availableTimeEnd
  • isSigned — int(2)
  • backgroundImageUrl
  • introduction

CreatorDate (Untitled18)

  • id — Primary key — NOT NULL
  • DateId — Foreign key → Date.id — NOT NULL
  • Field — Foreign key → Creator.Field

CreatorHashTag (CopyOfUntitled4)

  • Key2 — Primary key — NOT NULL
  • Key — Foreign key → HashTag.idi — NOT NULL
  • Field — Foreign key → Creator.Field

CreatorLanguage (Untitled10)

  • id — Primary key — NOT NULL
  • languageTitleId — Foreign key → LanguageTitle.Key — NOT NULL
  • Field — Foreign key → Creator.Field

CreatorPlatform (Untitled20)

  • id — Primary key — NOT NULL
  • PlatformId — Foreign key → platform.id — NOT NULL
  • CreatorId — Foreign key → Creator.Field

CreatorSubStatus (Untitled17)

  • id — Primary key — NOT NULL
  • ProjectMainStatusId (id2) — Foreign key → ProjectMainStatus.id — NOT NULL
  • creatorStatus (reason)

CreatorWeeklyCount (Untitled35)

  • Key — Primary key — NOT NULL
  • count — Foreign key → Creator.Field

CreatorWeeklyCount (CopyOfUntitled29)

  • id — Primary key — NOT NULL
  • CreatorId — Foreign key → Creator.Field
  • count (Field2)

Date (Untitled9)

  • id — Primary key — NOT NULL
  • date

Filter (Untitled)

  • id — Primary key — NOT NULL
  • priceCategoryId — Foreign key → PriceCategory.Key — NOT NULL
  • UserId — Foreign key → User.id — NOT NULL
  • title
  • video
  • introduction
  • QRLink
  • thumbnailUrl

FilterCount (Untitled28)

  • Key — Primary key — NOT NULL
  • FilterId — Foreign key → Filter.id — NOT NULL
  • count
  • Field
  • weekCount

FilterHashTag (CopyOfUntitled42)

  • Key2 — Primary key — NOT NULL
  • id — Foreign key → Filter.id — NOT NULL
  • Key — Foreign key → HashTag.idi — NOT NULL

FilterPlatform (Untitled21)

  • Key — Primary key — NOT NULL
  • FilterId (FilterIf) — Foreign key → Filter.id — NOT NULL
  • PlatformId — Foreign key → platform.id — NOT NULL

FilterStyle (Untitled6)

  • Key — Primary key — NOT NULL
  • FilterId — Foreign key → Filter.id — NOT NULL
  • styleId — Foreign key → Style.Key — NOT NULL

FilterTracker (CopyOfUntitled8)

  • Key — Primary key — NOT NULL
  • templateId — Foreign key → Filter.id — NOT NULL
  • Key (Key2) — Foreign key → Tracker.Key — NOT NULL

FilterWeeklyCount (Untitled29)

  • id — Primary key — NOT NULL
  • FilterId — Foreign key → Filter.id — NOT NULL
  • count

Following (Untitled23)

  • Key — Primary key — NOT NULL
  • CreatorId — Foreign key → Creator.Field
  • UserId — Foreign key → User.id — NOT NULL

HashTag (Untitled4)

  • idi (d) — Primary key — NOT NULL
  • name

LanguageTitle (Untitled12)

  • Key — Primary key — NOT NULL
  • name
  • image

Mood (moods)

  • Key — Primary key — NOT NULL
  • mood

MyTemplate (Untitled32)

  • Key — Primary key — NOT NULL
  • UserId — Foreign key → User.id — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL
  • downloadLink
  • thumbnail

PROGRESSSTATUS (Untitled26)

  • id — Primary key — NOT NULL
  • status — string

Payment (Untitled22)

  • Key — Primary key — NOT NULL
  • price
  • ProjectId — Foreign key → Project.Key — NOT NULL
  • Field

PriceCategory (Untitled11)

  • Key — Primary key — NOT NULL
  • type

Pricing (pricing)

  • id — Primary key — NOT NULL
  • priceCategoryId — Foreign key → PriceCategory.Key — NOT NULL
  • name
  • title
  • information
  • price
  • term
  • editCount
  • ideaProposal
  • UserId — Foreign key → User.id — NOT NULL

Project (Untitled13)

  • Key — Primary key — NOT NULL
  • UserId — Foreign key → User.id — NOT NULL
  • CreatorId — Foreign key → User.id — NOT NULL
  • PriceCategoryId — Foreign key → PriceCategory.Key — NOT NULL
  • StatusId — Foreign key → ProjectMainStatus.id — NOT NULL
  • ProgressId (id) — Foreign key → PROGRESSSTATUS.id — NOT NULL
  • title
  • clientName
  • startDate
  • dueDate
  • availableTimeStart
  • availableTimeEnd
  • purpose
  • projectNumber
  • isAgree
  • clientBrand

ProjectFile (Untitled14)

  • id — Primary key — NOT NULL
  • ProjectId — Foreign key → Project.Key — NOT NULL
  • link

ProjectMainStatus (Untitled15)

  • id — Primary key — NOT NULL
  • mainStatus (status)

ProjectPlatform (Untitled24)

  • Key — Primary key — NOT NULL
  • ProjectId — Foreign key → Project.Key — NOT NULL
  • PlatformId — Foreign key → platform.id — NOT NULL

ProjectSubStatus (Untitled25)

  • Key — Primary key — NOT NULL
  • id — Foreign key → ClientSubStatus.id — NOT NULL
  • id (id2) — Foreign key → CreatorSubStatus.id — NOT NULL
  • Key (Key2) — Foreign key → Project.Key — NOT NULL

Reason (Untitled27)

  • id — Primary key — NOT NULL
  • ProjectId — Foreign key → Project.Key — NOT NULL
  • reason

Style (Untitled2)

  • Key — Primary key — NOT NULL
  • style

Template (Untitled30)

  • Key — Primary key — NOT NULL
  • priceId — Foreign key → TemplatePrice.Key — NOT NULL
  • title
  • introduction
  • thumbnail
  • likeCount
  • video
  • maker

TemplateHashTag (Untitled31)

  • id — Primary key — NOT NULL
  • TemplateId — Foreign key → HashTag.idi — NOT NULL
  • HashTagId — Foreign key → Template.Key — NOT NULL

TemplateLike (Untitled33)

  • Key — Primary key — NOT NULL
  • UserId — Foreign key → User.id — NOT NULL
  • TemplateId — Foreign key → Template.Key — NOT NULL

TemplatePrice (Untitled34)

  • Key — Primary key — NOT NULL
  • price

Theme (Untitled3)

  • Key — Primary key — NOT NULL
  • theme

Tracker (trackers)

  • Key — Primary key — NOT NULL
  • tracker

User (users)

  • id — Primary key — NOT NULL
  • name
  • email
  • password
  • nickname
  • profileImageUrl
  • gmt
  • isMeta
  • isReceiveEmail

filterMood (Untitled7)

  • Key — Primary key — NOT NULL
  • FilterId — Foreign key → Filter.id — NOT NULL
  • moodId — Foreign key → Mood.Key — NOT NULL

filterTheme (Untitled8)

  • Key — Primary key — NOT NULL
  • FilterId — Foreign key → Filter.id — NOT NULL
  • Key (Key2) — Foreign key → Theme.Key — NOT NULL

like (Untitled5)

  • id — Primary key — NOT NULL
  • clientId — Foreign key → User.id — NOT NULL
  • templateId — Foreign key → Filter.id — NOT NULL

platform (Untitled19)

  • id — Primary key — NOT NULL
  • platform
  • image