ㅗㅓㅣ
Tables (69)
admin
- id — int — Primary key — NOT NULL — 아이디
- account — varchar(100) — NOT NULL — 계정
- password — varchar(256) — 패스워드
- name — varchar(100) — 관리자 이름
- email — varchar(100) — 인증용 메일
- adminRoleId — int — Foreign key → adminrole.id — 관리자 권한
- boothCompanyId — int — Foreign key → boothcompany.id
- alarmAccept — tinyint(1) — NOT NULL
- auth — tinyint(1) — NOT NULL
- logCount — int — 접속수
- createdTime — timestamp
- updatedTime — timestamp — 업데이트시간
- deletedTime — timestamp
adminrole
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- verifyCode — char(4)
- spaceId — int — Foreign key → spaces.id
- createdTime — timestamp — NOT NULL
- updatedTime — timestamp — NOT NULL
- deletedTime — timestamp
allstate
- id — int — Primary key — NOT NULL
- userId — int — userId
- socketId — varchar(255)
- spaceId — int — Foreign key → spaces.id
- joinTime — timestamp
- leftTime — timestamp
appversion
- id — int — Primary key — NOT NULL
- type — varchar(50)
- version — varchar(12)
audioresource
- audioResourceId — int — Primary key — NOT NULL
- audioTitle — varchar(1024)
- objectName — varchar(256)
- fileName — varchar(46)
- contentsUrl — varchar(1024)
- audioFlag — varchar(16)
- resourceCode — varchar(32)
- accessLevel — int
- public — char(1)
- audioDesc — varchar(256)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
avatarbuildtype
- id — int — Primary key — NOT NULL
- buildType — varchar(100)
avatargender
- id — int — Primary key — NOT NULL
- genderType — varchar(10) — 유저 아바타 성별
avatarmakeupmodel
- id — int — Primary key — NOT NULL
- makeUpTypeId — int — Foreign key → avatarmakeuptype.id
- buildTypeId — int — Foreign key → avatarbuildtype.id
- genderTypeId — int — Foreign key → avatargender.id
- color_red — int
- color_blue — int
- color_green — int
avatarmakeuptype
- id — int — Primary key — NOT NULL
- makeUpType — varchar(100)
avatarmaterial
- id — int — Primary key — NOT NULL
- partsModelId — int — Foreign key → avatarpartsmodel.id
- makeUpModelId — int
- material — varchar(100)
- group — int
- priority — int
avatarmorphmodel
- id — int — Primary key — NOT NULL
- generTypeId — int — Foreign key → avatargender.id
- morphTypeId — int — Foreign key → avatarmorphtype.id
- prioirty — int
avatarmorphpoint
- id — int — Primary key — NOT NULL
- morphModelId — int — Foreign key → avatarmorphmodel.id
- morphPoint — int
avatarmorphsetting
- id — int — Primary key — NOT NULL
- morphPointId — int — Foreign key → avatarmorphpoint.id
- setting — float
- option — varchar(100)
avatarmorphtype
- id — int — Primary key — NOT NULL
- morphType — varchar(100) — NOT NULL
avatarpartsmodel
- id — int — Primary key — NOT NULL
- partsTypeId — int — Foreign key → avatarpartstype.id
- genderTypeId — int — Foreign key → avatargender.id
- buildTypeId — int — Foreign key → avatarbuildtype.id
- baseMesh — varchar(100)
- baseMeshId — int
- groupIndex — int
- groupPriority — int
avatarpartstype
- id — int — Primary key — NOT NULL
- partsType — varchar(100)
balloonhistory
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → userinfo.userId
- balloon — int
- getTime — timestamp
boothcategory
- id — int — Primary key — NOT NULL
- title — varchar(30)
- createdTime — int
boothcompany
- id — int — Primary key — NOT NULL
- name — varchar(100) — 기업명
- businessNo — char(15)
- industryId — int — Foreign key → industry.id — 업종
- representative — varchar(20) — 대표자명
- tel — varchar(50)
- email — varchar(100)
- fax — varchar(50) — 팩스번호
- categoryId — int — Foreign key → companycategory.id
- categoryEtc — varchar(50)
- url — varchar(255) — 홈페이지
- address — varchar(500)
- incDate — timestamp — 설립년도
- logoUrl — varchar(255) — 기업로고url
- license — int — Foreign key → resource.id — 사업자등록증 파일 id
- info — varchar(255) — 기업소개
- priority — int — 배치순서
- approved — int
- boothTypeId — int — Foreign key → boothtype.id
- createdTime — int
- updatedTime — int
- deletedTime — int
boothcompanyen
- id — int — Primary key — NOT NULL
- name — varchar(100) — 기업명
- businessNo — char(15) — 사업자번호
- industryId — int — Foreign key → industry.id — 업종
- representative — varchar(20) — 대표자명
- tel — varchar(50)
- email — varchar(100)
- fax — varchar(50) — 팩스번호
- categoryId — int — Foreign key → companycategory.id — 기업분류
- categoryEtc — varchar(50) — 기업분류기타
- url — varchar(255) — 홈페이지
- address — varchar(500)
- logoUrl — varchar(255)
- incDate — timestamp — 설립년도
- license — int — Foreign key → resource.id — 사업자등록증 파일 id
- info — varchar(255) — 기업소개
- priority — int — 배치순서
- approved — int — 승인상태(0:대기,1:승인,2:거부)
- boothTypeId — int — Foreign key → boothtype.id
- createdTime — int
- updatedTime — int
- deletedTime — int
boothemployee
- id — int — Primary key — NOT NULL
- name — varchar(50) — 담당자명
- department — varchar(100)
- position — varchar(100) — 직책
- email — varchar(100) — 이메일
- hotline — varchar(50) — 연락처(직통번호)
- tel — varchar(50) — 휴대폰번호
- boothCompanyId — int — Foreign key → boothcompany.id — 전시기업 id
- infoAccept — int — 정보제공동의
- createdTime — int
- updatedTime — int
- deletedTime — int
boothemployeeen
- id — int — Primary key — NOT NULL
- name — varchar(50) — 담당자명
- department — varchar(100) — 부서
- position — varchar(100) — 직책
- email — varchar(100) — 이메일
- hotline — varchar(50) — 연락처(직통번호)
- tel — varchar(50) — 휴대폰번호
- boothCompanyId — int — Foreign key → boothcompanyen.id
- infoAccept — int — 정보제공동의
- createdTime — int
- updatedTime — int
- deletedTime — int
boothhistory
- id — int — Primary key — NOT NULL
- socketId — varchar(255)
- boothCompanyId — int
- userId — int
- joinTime — timestamp
- leftTime — timestamp
boothrejectmessage
- id — int — Primary key — NOT NULL
- boothCompanyId — int — Foreign key → boothcompany.id
- message — varchar(500)
boothtype
- id — int — Primary key — NOT NULL
- spaceId — int
- createdTime — int
chatlist
- id — int — Primary key — NOT NULL
- senderId — int — Foreign key → userinfo.userId — NOT NULL
- reciverId — int — Foreign key → userinfo.userId — NOT NULL
- isSenderRead — tinyint(1) — NOT NULL
- isReceiverRead — tinyint(1) — NOT NULL
cmsbasedata
- tableName — varchar(64) — Primary key — NOT NULL
- columnName — varchar(64) — Primary key — NOT NULL
- position — smallint
- field — varchar(64)
- label — varchar(64)
- type — varchar(16)
- attr — varchar(256)
- len — int
- required — tinyint
- hidden — varchar(8)
- hidden1 — tinyint
- disabled — tinyint
- sortable — tinyint
- searchable — tinyint
- render — text
- editable — tinyint
- fieldText — text
- customView — varchar(16)
- createButtonView — varchar(10)
- column_key — varchar(16)
- extra — varchar(16)
codemaster
- seqId — int — Primary key — NOT NULL
- tableName — varchar(64)
- position — varchar(64)
- columnName — varchar(32)
- dataType — varchar(32)
- length — smallint
- default — char(1)
- val — varchar(32)
- displayText — varchar(512)
- comment — varchar(1024)
company
- id — int — Primary key — NOT NULL
- spaceId — int — Foreign key → spaces.id
- title — varchar(255) — NOT NULL
- verifyCode — char(4)
- createdTime — timestamp
- updatedTime — timestamp
companycategory
- id — int — Primary key — NOT NULL
- name — varchar(100)
conference
- id — int — Primary key — NOT NULL
- title — varchar(100) — 컨퍼런스명
- title_en — varchar(100)
- password — varchar(20) — 암호
- visible — tinyint — 노출여부
- createdTime — int
conferencehistory
- id — int — Primary key — NOT NULL
- socketId — varchar(255)
- conferenceId — int
- userId — int
- joinTime — timestamp
- leftTime — timestamp
conferencespeaker
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → userinfo.userId — 사용자 id
- conferenceId — int — Foreign key → conference.id — 컨퍼런스 id
- institution — varchar(50) — 주최기관
- institution_en — varchar(50)
- name — varchar(50) — 발표자명
- name_en — varchar(50)
- tel — varchar(20) — 전화번호
- email — varchar(50) — 이메일
- completed — tinyint — 발표완료여부
- createdTime — int
content
- id — int — Primary key — NOT NULL
- title — varchar(100)
- title_en — varchar(256)
- contentType — varchar(50) — 콘텐츠 타입 영상 or 베너
- resourceId — int — Foreign key → resource.id
- worldId — int — Foreign key → world.id
- spaceId — int — Foreign key → spaces.id
- categoryId — int — Foreign key → contentcategory.id
- boothCompanyId — int — Foreign key → boothcompany.id
- locationId — int — Foreign key → contentlocation.id
- priority — int
- description — varchar(1000) — 콘텐츠 설명(경북도청)
- description_en — varchar(1000)
- link — varchar(255) — 콘텐츠 링크
- youtube — varchar(255) — 유튜브 링크
- createdTime — int
- updatedTime — int
- deletedTime — int
- createdBy — int — Foreign key → admin.id
contentcategory
- id — int — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- createdTime — int — create time (format :unix time)
- updatedTime — int — create time (format :unix time)
contentlocation
- id — int — Primary key — NOT NULL
- title — varchar(100)
contentviewhistory
- id — int — Primary key — NOT NULL
- spaceId — int — Foreign key → spaces.id
- contentId — int — Foreign key → content.id
- userId — int — Foreign key → userinfo.userId
- viewAt — timestamp
errorcodemaster
- errorCode — int — Primary key — NOT NULL
- errorMessage — varchar(256)
- createTime — int
- updateTime — int
exhibitionnotice
- id — int — Primary key — NOT NULL
- title — varchar(255) — 제목
- title_en — varchar(255)
- noticeContent — longtext — 내용
- noticeContent_en — text
- boothCompanyId — int — Foreign key → boothcompany.id — 전시기업 id
- viewCount — int — 조회수
- createdBy — int — Foreign key → admin.id — 작성자
- createdTime — timestamp
- updatedTime — timestamp
fileresource
- fileResourceId — int — Primary key — NOT NULL
- fileTitle — varchar(1024)
- objectName — varchar(256)
- fileName — varchar(46)
- contentsUrl — varchar(1024)
- resourceCode — varchar(32)
- accessLevel — int
- public — char(1)
- fileDesc — varchar(256)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
imageresource
- imageResourceId — int — Primary key — NOT NULL
- imageTitle — varchar(1024)
- objectName — varchar(256)
- fileName — varchar(46)
- contentsUrl — varchar(1024)
- resourceCode — varchar(32)
- accessLevel — int
- public — char(1)
- imageDesc — varchar(256)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
industry
- id — int — Primary key — NOT NULL
- title — varchar(100)
- createdTime — int
langtype
- id — int — Primary key — NOT NULL
- title — varchar(15) — NOT NULL
linkresource
- linkResourceId — int — Primary key — NOT NULL
- linkTitle — varchar(1024)
- objectName — varchar(256)
- linkName — varchar(46)
- contentsUrl — varchar(1024)
- resourceCode — varchar(32)
- accessLevel — int
- public — char(1)
- linkDesc — varchar(256)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
location
- id — int — Primary key — NOT NULL
- location — varchar(100)
- url — varchar(512) — NOT NULL
message
- id — int — Primary key — NOT NULL
- listId — int — Foreign key → chatlist.id — NOT NULL
- senderId — int — Foreign key → userinfo.userId — NOT NULL
- reciverId — int — Foreign key → userinfo.userId — NOT NULL
- message — varchar(512) — NOT NULL
notice
- noticeId — int — Primary key — NOT NULL
- title — varchar(256)
- title_en — varchar(256)
- noticeContent — text — NOT NULL
- noticeContent_en — text
- objectName — varchar(256) — attach notice Image file (aws key values)
- fileName — varchar(48) — attach file name
- contentsUrl — varchar(512) — service web url
- createUser — int — Foreign key → admin.id
- updateUser — int
- noticeType — int — Foreign key → noticetype.id — notice type
- createTime — int — NOT NULL — create time (format :unix time)
- updateTime — int — NOT NULL — update time (format :unix time)
- reservatedTime — int
- standardTime — varchar(100)
noticetype
- id — int — Primary key — NOT NULL
- noticeType — varchar(100)
noticeviewhistory
- id — int — Primary key — NOT NULL
- noticeId — int — Foreign key → notice.noticeId
- userId — int — Foreign key → userinfo.userId
- viewAt — int
npcscript
- id — int — Primary key — NOT NULL
- npcId — int — Foreign key → worldnpc.id
- script — varchar(100) — NOT NULL
- script_en — varchar(200)
- url — varchar(255)
- createdTime — int
- updatedTime — int
- deletedTime — int
- createdBy — int
openapi
- id — int — Primary key — NOT NULL
- genderId — int — Foreign key → avatargender.id
- url — varchar(512)
openapikey
- id — int — Primary key — NOT NULL
- government — varchar(100) — local government
product
- id — int — Primary key — NOT NULL
- name — varchar(100) — 상품명
- name_en — varchar(100)
- model — varchar(1000) — embed코드
- priority — int
- companyId — int — Foreign key → contentcategory.id
- locationId — int — Foreign key → contentlocation.id
- spaceId — int — Foreign key → spaces.id
- createdBy — int — Foreign key → admin.id
- description — varchar(1000)
- description_en — varchar(1000)
- createdTime — int
- updatedTime — int
- deletedTime — int
resource
- id — int — Primary key — NOT NULL
- name — varchar(100)
- type — varchar(50)
- url — varchar(512)
- link — varchar(255)
- createdTime — int
- updatedTime — int
- createdBy — int
roomtotemplate
- roomId — int — Primary key — NOT NULL — room id
- roomTemplateId — int — Primary key — NOT NULL
spaceplatformhistory
- id — int — Primary key — NOT NULL
- spaceId — int
- boothCompanyId — int — Foreign key → boothcompany.id
- conferenceId — int — Foreign key → conference.id
- userId — int — Foreign key → userinfo.userId
- platform — varchar(50)
- joinTime — timestamp
spaces
- id — int — Primary key — NOT NULL
- worldId — int — Foreign key → world.id
- title — varchar(255) — NOT NULL
- priority — int
- url — varchar(255)
- password — varchar(10) — 공간 패스워드
- createdTime — timestamp — NOT NULL
- updatedTime — timestamp — NOT NULL
- deletedTime — timestamp
template
- templateId — int — Primary key — NOT NULL
- templateTitle — varchar(128)
- templateDesc — varchar(128)
- accessLevel — int
- public — char(1)
- sortOrder — int
- templateCode — varchar(32)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
useravatar
- id — int — Primary key — NOT NULL — 유저 고급형아바타
- hair — json — 머리스타일
- face — json — 얼굴 생김새
- top — json — 상의
- bottom — json — 하의
- shoes — json — 신발
- set — json — 세트
- hat — json — 모자
- glasses — json — 안경
- earring — json — 귀걸이
- piercing — json — 피어싱
- beard — json — 수염
- necklace — json — 목걸이
- bag — json — 가방
- bracelet — json — 펄찌
- glove — json — 장갑
- anklet — json — 발찌
- cheek — json — 볼터치
- lips — json — 입술색
- skin — json — 피부색
- eyeShadow — json — 아이쉐도우
- pupil — json — 눈동자
- userId — int — 유저 PK ID
- avatarType — smallint
- createTime — timestamp
- updateTime — timestamp
useravatarmorph
- id — int — Primary key — NOT NULL — 유저 고급형아바타
- eyebrow — json — 눈썹
- eye — json — 눈
- nose — json — 코
- lips — json — 입술
- jaw — json — 턱
- ear — json — 귀
- morphType — json
- userId — int — 유저 PK ID
- createTime — timestamp
- updateTime — timestamp
userblock
- id — int — Primary key — NOT NULL
- userId — int — NOT NULL
- blockUserId — int — Foreign key → userinfo.userId — NOT NULL
- createTime — int
- deleteTime — int
userhistory
- historyId — int — Primary key — NOT NULL
- userId — int — NOT NULL
- clientIp — varchar(100)
- successFlag — varchar(2) — NOT NULL
- device — varchar(20) — pc/mobile
- loginTime — int
- logoutTime — int
- failTime — int
userinfo
- userId — int — Primary key — NOT NULL — User ID(seq)
- userName — varchar(32) — NOT NULL — User Name(Nick Name)
- email — varchar(32) — email
- password — varchar(256) — password
- sex — varchar(2) — NOT NULL — M: male, F:female
- birth — varchar(16)
- FBuid — varchar(128)
- auth — tinyint — 이메일 인증여부
- userSnsService — varchar(20) — NOT NULL
- alarmAccept — varchar(2)
- attemptCount — smallint
- createTime — int — create time (format :unix time)
- updateTime — int — update time (format :unix time)
- deleteTime — int
usersession
- userId — int — Primary key — NOT NULL — User ID(seq)
- sessionKey — varchar(48) — NOT NULL
- createTime — int — NOT NULL — create time (format :unix time)
- updateTime — int
videoresource
- videoResourceId — int — Primary key — NOT NULL
- videoTitle — varchar(1024)
- videoObjectName — varchar(256)
- videoFileName — varchar(46)
- videoContentsUrl — varchar(1024)
- videoFlag — varchar(16)
- resourceCode — varchar(32)
- accessLevel — int
- public — char(1)
- videoDesc — varchar(256)
- createUser — int
- updateUser — int
- createTime — int
- updateTime — int
weblink
- id — int — Primary key — NOT NULL
- joinTime — varchar(100) — webpage joinTime
- count — int — page count
world
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- worldTemplateId — int
- priority — int — NOT NULL
- introduction — varchar(255) — 소개글
- resource — varchar(100)
- createdTime — timestamp — NOT NULL
- updatedTime — timestamp — NOT NULL
worldadmin
- id — int — Primary key — NOT NULL
- account — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- adminRoleId — int — 관리자 역활 ID
- createdTime — timestamp — NOT NULL
- updatedTime — timestamp — NOT NULL
- deletedTime — timestamp
worldnpc
- id — int — Primary key — NOT NULL
- name — varchar(20) — npc명
- name_en — varchar(20)
- worldId — int — Foreign key → world.id
- spaceId — int — Foreign key → spaces.id
- categoryId — int — Foreign key → contentcategory.id — 면세점 분류