make

Tables (11)

Business

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → User.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • companyName — varchar(255)
  • crDir — varchar(255)
  • crFileName — varchar(255)
  • crNumber — varchar(255)
  • crOriginName — varchar(255)
  • managerEmail — varchar(255)
  • managerName — varchar(255)
  • managerNumber — varchar(255)
  • idUser — bigint(20)

CarWash

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → User.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • Reservation — datetime
  • address — varchar(255)
  • area — varchar(255)
  • phoneNumber — varchar(255)

Commerce

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → User.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • address — varchar(255)
  • addressDetail — varchar(255)
  • building — varchar(255)
  • companyName — varchar(255)
  • crNumber — varchar(255)
  • managerEmail — varchar(255)
  • managerName — varchar(255)
  • managerNumber — varchar(255)
  • orderStatus — varchar(255)
  • request — varchar(255)

Disinfection

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → User.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • Reservation — datetime
  • address — varchar(255)
  • area — varchar(255)
  • phoneNumber — varchar(255)

Dwelling

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → User.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • address — varchar(255)
  • addressDetail — varchar(255)
  • area — varchar(255)
  • cleanNum — int(11)
  • cleanTime — datetime
  • cleanType — varchar(255)
  • nextCleanTime — datetime
  • reservation — datetime
  • residentialSpace — varchar(255)

OrderCleanType

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → Dwelling.id — NOT NULL
  • id (id22) — bigint(20) — Foreign key → Dwelling.id — NOT NULL
  • CleanTypeId — bigint(20)
  • DwellingId — bigint(20)

User

  • id — bigint(20) — Primary key — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • isDormancy — bit(1)
  • dormancyTime — datetime
  • lastLoginDate — datetime
  • email — varchar(255) — NOT NULL
  • isLeave — bit(1)
  • leaveReason — text
  • leaveTime — datetime
  • removePrivacyTime — datetime
  • mobile — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • appleId — varchar(50)
  • appleName — varchar(50)
  • facebookId — varchar(50)
  • facebookName — varchar(50)
  • googleId — varchar(50)
  • googleName — varchar(50)
  • kakaoId — varchar(50)
  • kakaoName — varchar(50)
  • naverId — varchar(50)
  • naverName — varchar(50)
  • taEft — bit(1)
  • taLocation — bit(1)
  • taPrivacy — bit(1)
  • taService — bit(1)
  • accountNonExpired — bit(1)
  • accountNonLocked — bit(1)
  • credentialsNonExpired — bit(1)
  • enabled — bit(1)
  • updatedPasswordDateTime — datetime — NOT NULL
  • vEmail — bit(1)
  • vMobile — bit(1)

WorkDetail

  • id — bigint(20) — Primary key — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)

WorkHistory

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → Commerce.id — NOT NULL
  • id (id22) — bigint(20) — Foreign key → Commerce.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • acreage — varchar(255)
  • area — varchar(255)
  • detailWork — varchar(255)
  • money — bigint(20)
  • num — varchar(255)

WorkList

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → WorkHistory.id — NOT NULL
  • id (id22) — bigint(20) — Foreign key → WorkHistory.id — NOT NULL
  • id (id222) — bigint(20) — Foreign key → WorkHistory.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • endWorkTime — datetime
  • startWorkTime — datetime
  • residentialSpace — varchar(255)
  • workHistoryId — bigint(20)
  • workerId — bigint(20)

Worker

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → WorkList.id — NOT NULL
  • id (id22) — bigint(20) — Foreign key → WorkList.id — NOT NULL
  • id (id222) — bigint(20) — Foreign key → WorkList.id — NOT NULL
  • id (id2222) — bigint(20) — Foreign key → WorkList.id — NOT NULL
  • createdBy — bigint(20)
  • createdDate — datetime
  • updatedBy — bigint(20)
  • updatedDate — datetime
  • version — bigint(20)
  • WorkerName — varchar(255)
  • active — bit(1)
  • endJoin — datetime
  • startJoin — datetime
  • CleanTypeId — bigint(20)