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)