new
Tables (14)
advertisement_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- advertiserName — varchar(255) — NOT NULL
- advertiserEmail — varchar(255) — NOT NULL
- advertiserTel — varchar(255) — NOT NULL
- adType — enum('TOP_AD', 'MIDDLE_AD', 'BOTTOM_AD', 'MAIN_BANNER', 'POWERLINK', 'PAGE_BANNER') — NOT NULL
- adPeriod — enum('1', '3', '6', '12') — NOT NULL
- startedAt — date — NOT NULL
- finishedAt — date — NOT NULL
- promotionSentenceList — text
- advertiserId — int
branch_info_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- name — varchar(255)
- tel — varchar(255)
- email — varchar(255)
- address — varchar(255)
- businessId — int
business
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- businessName — varchar(255) — NOT NULL
- address — varchar(255) — NOT NULL
- businessRegisterNo — varchar(255) — NOT NULL
- representImage — varchar(255)
- logo — varchar(255)
- representSentence — varchar(255)
- link — varchar(255)
- businessScale — varchar(255)
- businessTel — varchar(255) — NOT NULL
- businessEmail — varchar(255) — NOT NULL
- businessType — varchar(255) — NOT NULL
- businessStartDate — datetime
- representContent — varchar(255)
- authList — text
- specializedServiceList — text
- brochureTitle — varchar(255)
- brochurePath — varchar(255)
- primaryCountryList — text
- likeCnt — int — NOT NULL
- viewCnt — int — NOT NULL
- ceoName — varchar(255) — NOT NULL
business_manager_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- position — varchar(255)
- task — varchar(255)
- name — varchar(255)
- phoneNumber — varchar(255)
- email — varchar(255)
- businessId — int
employee_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- invitationAllowed — tinyint — NOT NULL
- businessId — int — NOT NULL
- employeeId — int — NOT NULL
hate_post_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- postCategory — enum('QuestionPost', 'CommunityPost', 'NewsCenterPost', 'RecruitmentPost', 'OpinionPost') — NOT NULL
- postId — varchar(255) — NOT NULL
- larchiveProfileId — int — NOT NULL
larchive_profile_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- exp — int — NOT NULL
- isSpecialist — tinyint — NOT NULL
- level — int — NOT NULL
- likeCompnyList — text
- writtenCommentList — text
- likedCommentList — text
liked_post_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- postCategory — enum('QuestionPost', 'CommunityPost', 'NewsCenterPost', 'RecruitmentPost', 'OpinionPost') — NOT NULL
- postId — varchar(255) — NOT NULL
- larchiveProfileId — int — NOT NULL
message_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- readAt — datetime
- isPinnedBySender — tinyint — NOT NULL
- isPinnedByReceiver — tinyint — NOT NULL
- deletedAtBySender — datetime
- deletedAtByReceiver — datetime
- senderId — int — NOT NULL
- receiverId — int — NOT NULL
order_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- productAdId — int
- consumerId — int
payment_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- orderId — int
scrap_post_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- postCategory — enum('QuestionPost', 'CommunityPost', 'NewsCenterPost', 'RecruitmentPost', 'OpinionPost') — NOT NULL
- postId — varchar(255) — NOT NULL
- addedDate — datetime — NOT NULL
- larchiveProfileId — int
user
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- nickName — varchar(255) — NOT NULL
- outputRefCode — varchar(255) — NOT NULL
- inputRefCode — varchar(255)
- isDeleted — tinyint — NOT NULL
- deletedAt — date
- tel — varchar(255) — NOT NULL
- userAccountStatus — tinyint — NOT NULL
- lastLoginAt — date
- isBusinessAccount — tinyint — NOT NULL
- memoByAdmin — varchar(255)
- adminRoleList — text
- adminName — varchar(255)
- condition_1_ok_At — datetime
- condition_2_ok_At — datetime
- emailVerified — tinyint — NOT NULL
- whichSns — enum('local', 'kakao', 'naver', 'google') — NOT NULL
- profilePhoto — varchar(255)
- interest — text
- userType — varchar(255) — NOT NULL
- introduction — varchar(255)
- connectedBusinessId — int
- managedBusinessId — int
- country — varchar(255) — NOT NULL
- larchiveProfileId — int
written_post_mysql
- id — int
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- postCategory — enum('QuestionPost', 'CommunityPost', 'NewsCenterPost', 'RecruitmentPost', 'OpinionPost') — NOT NULL
- postId — varchar(255) — NOT NULL
- larchiveProfileId — int — NOT NULL