ㅗㅓㅣ

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 — 면세점 분류