Gyeongbuk ERD
Tables (24)
AlamConsent
- id — INT
- userId — INT
- mapId — VARCHAR(255)
- contentsNumber — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Avatar
- userId — INT
- hair — INT
- top — INT
- bottom — INT
- shoes — INT
- gender — INT
- realAvatarId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
BlockUser
- id — INT
- userId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
BoothContents
- id — INT
- eventId — INT
- userId — INT
- title — VARCHAR(255)
- description — VARCHAR(255)
- content — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
CompanyInfo
- userId — INT
- companyName — VARCHAR(255)
- tCompanyName — INT
- about — VARCHAR(255)
- tAbout — INT
- logoFileId — VARCHAR(255)
- ceoName — VARCHAR(255)
- tCeoName — INT
- businessRegistrationNumber — VARCHAR(255)
- establishmentYear — INT
- address — VARCHAR(255)
- tAddress — INT
- phoneId — INT
- faxId — INT
- email — VARCHAR(255)
- linkId — INT
- description — VARCHAR(255)
- tDescription — INT
- businessRegistrationFileId — VARCHAR(255)
- bankBookFileId — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
Consent
- id — INT
- userId — INT
- mapId — VARCHAR(255)
- contentsNumber — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Event
- id — INT
- title — VARCHAR(255)
- startDate — DATETIME
- endDate — DATETIME
- topic — VARCHAR(255)
- sponsor — VARCHAR(255)
- organize — VARCHAR(255)
- description — VARCHAR(255)
- eventState — INT
- maxUser — INT
- mainImageFileId — VARCHAR(255)
- photonId — INT
- adminId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
EventCategory
- id — INT
- eventId — INT
- name — VARCHAR(255)
EventManagerUser
- eventId — INT
- userId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
EventReservedUser
- eventId — INT
- userId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
File
- id — VARCHAR(255)
- fileKey — VARCHAR(255)
- originalFileName — VARCHAR(255)
- storageFileName — VARCHAR(255)
- mimeType — VARCHAR(255)
- fileSize — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Link
- id — INT
- homePage — VARCHAR(255)
- blog — VARCHAR(255)
- facebook — VARCHAR(255)
- instagram — VARCHAR(255)
- youtube — VARCHAR(255)
- kakao — VARCHAR(255)
- companyInfoId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Map
- id — VARCHAR(255)
- sequenceNumber — INT
- mapGroupId — VARCHAR(255)
- name — VARCHAR(255)
- alias — VARCHAR(255)
- isPublic — BOOLEAN
- allowRoom — BOOLEAN
- gameMapId — INT
- linkingMapId — VARCHAR(255)
- broadcasterId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
MapAllowUser
- userId — INT
- mapId — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
MapChatMessage
- id — INT
- userId — INT
- mapChatRoomId — INT
- text — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
MapChatRoom
- id — INT
- mapId — VARCHAR(255)
- name — VARCHAR(255)
- type — INT
- createdAt — DATETIME
- updatedAt — DATETIME
MapGroup
- id — VARCHAR(255)
- eventId — INT
- isShow — BOOLEAN
- sequenceNumber — INT
- thumbnailFileId — VARCHAR(255)
- name — VARCHAR(255)
- tName — INT
- description — VARCHAR(255)
- tDescription — INT
- gameMapType — INT
- createdAt — DATETIME
- updatedAt — DATETIME
MapVideoContent
- mapId — VARCHAR(255)
- videoContentId — INT
- contentsNumber — INT
- createdAt — DATETIME
Phone
- id (Key) — INT — Primary key — NOT NULL
- companyInfoPhoneId (Key2) — INT — Primary key — NOT NULL
- companyInfoFaxId (Key3) — INT — Primary key — NOT NULL
- userId — INT
- companyInfoPhoneId — INT
- companyInfoFaxId — INT
- countryCode — VARCHAR(255)
- areaCode — VARCHAR(255)
- prefix — VARCHAR(255)
- lineNumber — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
RealAvatar
- avatarId — INT
- faceFileId — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
TranslationContent
- id — INT
- tName — INT
- tAbout — INT
- tCeoName — INT
- tAddress — INT
- tDescription — INT
User
- id (Key) — INT — Primary key — NOT NULL
- validationId — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- userState — INT
- globalRole — INT
- phoneId — INT
- profileImageFileId — VARCHAR(255)
- userDetail — JSON
- avatarId — INT
- companyInfoId — INT
- mapBroadcasterList — JSON
- alertList — JSON
- fileList — JSON
- eventListAdmin — JSON
- chatMessageList — JSON
- boothContentsList — JSON
- alamConsentList — JSON
- consentList — JSON
- eventManagerUserList — JSON
- userChatRoomList — JSON
- mapAllowUserList — JSON
- eventReservedUserList — JSON
- blockUserList — JSON
- webContactList — JSON
- createdAt — DATETIME
- updatedAt — DATETIME
UserChatMessage
- id — INT
- userId — INT
- chatRoomId — INT
- text — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
UserChatRoom
- id — INT
- userId — INT
- name — VARCHAR(255)
- type — INT
- createdAt — DATETIME
- updatedAt — DATETIME