GigaLive

 

 
tbAccumWatch  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cnt

decimal(10,0)

(NULL)

YES

 

0

 

select,insert,update,references

 

hidden

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

remain_count

varchar(255)

utf8_general_ci

YES

 

0

 

select,insert,update,references

 

wKey

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

Indexes

Back

 
tbAd  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

castCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송코드

castId

varchar(100)

utf8_general_ci

NO

 

manager

 

select,insert,update,references

방송자 아이디

watchCnt

decimal(10,0)

(NULL)

NO

 

0

 

select,insert,update,references

시청수

castTitle

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송 주제

nickName

varchar(100)

utf8_general_ci

NO

 

 

 

select,insert,update,references

방송자 닉네임

profileImage

varchar(500)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자 프로필 이미지

castType

int(11)

(NULL)

NO

 

1

 

select,insert,update,references

방송 형태

castPath

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송 매체

exposeOrder

int(11)

(NULL)

NO

 

1

 

select,insert,update,references

노출순서

exposeYN

char(1)

utf8_general_ci

NO

 

Y

 

select,insert,update,references

노출여부

castStartDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송시작일자

castEndDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송종료일자

episode

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

방송회차

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송자소속로고

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbAd

0

PRIMARY

1

castCode

A

4

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbBlackList  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mcId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송자아이디

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

regDate

varchar(10)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

등록일자

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbBlackList

0

PRIMARY

1

mcId

A

1

(NULL)

(NULL)

 

BTREE

 

 

tbBlackList

0

PRIMARY

2

userId

A

1

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbCategory  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

category

int(11)

(NULL)

NO

PRI

(NULL)

 

select,insert,update,references

주제아이디

programName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

프로그램이름

programDate

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

프로그램일자

programTime

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

프로그램시간

programDue

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

프로그램방영시간

programMake

varchar(300)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

프로그램PD

programIntro

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

프로그램소개

programPurpose

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

프로그램목적

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbCategory

0

PRIMARY

1

category

A

1

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbCategoryPeople  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

category

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

방송주제아이디

peopleName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

프로그램명

peopleImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

프로그램이미지

peopleHistory

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

프로그램히스토리

Indexes

Back

 
tbFavorite  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mcId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송자아이디

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbFavorite

0

PRIMARY

1

mcId

A

5

(NULL)

(NULL)

 

BTREE

 

 

tbFavorite

0

PRIMARY

2

userId

A

5

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbFilterText  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nowVersion

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

버전

filterText

varchar(10000)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

차단문자열

Indexes

Back

 
tbLiveList  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

castCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송코드

castId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

watchCnt

decimal(10,0)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

시청수

castTitle

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송주제

castPath

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

0:android 1:ios 2:studio 방송매체

nickName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자닉네임

profileImage

varchar(500)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자프로필이미지

castType

int(3)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

방송형태

castStartDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송시작일

castEndDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송종료일

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송로고이미지

episode

int(11)

(NULL)

YES

 

1

 

select,insert,update,references

방송회차

sortBig

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

업종 대분류

sortMid

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

업종 중분류

sortSmall

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

업종 소분류

location

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

지역코드

store

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

상호 코드

product

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

상품코드

likes

varchar(500)

utf8_general_ci

YES

 

0

 

select,insert,update,references

좋아요수

accumWatchCnt

varchar(500)

utf8_general_ci

YES

 

0

 

select,insert,update,references

누적 시청자수

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbLiveList

0

PRIMARY

1

castCode

A

57

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbManager  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mcId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

userId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

시청자아이디

Indexes

Back

 
tbMCList  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mcId

varchar(100)

macce_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송자아이디

nickName

varchar(100)

macce_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자닉네임

followCnt

decimal(10,0)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

팔로워수

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbMCList

0

PRIMARY

1

mcId

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbPayedLog  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

biling_key

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

빌링키

type

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

개인/단체여부 개인 1 단체 2

regdate

timestamp

(NULL)

NO

 

current_timestamp()

 

select,insert,update,references

 

price

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

status

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

order_id

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

item_name

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

data

text

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

start_date

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

end_date

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

result

text

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

card_no

varchar(20)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

cardvalid_ym

varchar(10)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

phone

varchar(50)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbPayedLog

0

PRIMARY

1

userId

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbScheduledLive  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

castCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송코드

castId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

watchCnt

decimal(10,0)

(NULL)

NO

 

0

 

select,insert,update,references

시청수

castTitle

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송주제

castPath

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송매체

nickName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자닉네임

profileImage

varchar(500)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자프로필이미지

castStartDate

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송시작일

castType

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송형태

castEndDate

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송종료일자

episode

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

방송회차

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송로고이미지

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbScheduledLive

0

PRIMARY

1

castCode

A

1

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbSubscribe  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

biling_key

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

빌링키

type

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

개인/단체여부 개인 1 단체 2

regdate

timestamp

(NULL)

NO

 

current_timestamp()

 

select,insert,update,references

 

price

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

order_id

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

start_date

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

end_date

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

card_no

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

cardvalid_ym

varchar(6)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

phone

varchar(20)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

buyer_nm

varchar(50)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

email_addr

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

product_nm

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

product_cd

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbSubscribe

0

PRIMARY

1

userId

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbTopBanner  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

castCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송코드

castId

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송자아이디

watchCnt

decimal(10,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

시청수

castTitle

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

방송주제

nickName

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송자닉네임

profileImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송자프로필이미지

castType

int(11)

(NULL)

NO

 

5

 

select,insert,update,references

방송형태

castPath

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

방송매체

exposeOrder

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

노출순서

exposeYN

char(1)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

노출여부

castStartDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방솔시작일

castEndDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송종료일

episode

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

방송회차

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송로고이미지

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbTopBanner

0

PRIMARY

1

castCode

A

3

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbTopLive  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

castCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

방송코드

castId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

watchCnt

decimal(10,0)

(NULL)

NO

 

0

 

select,insert,update,references

시청자수

castTitle

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송주제

nickName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자닉네임

profileImage

varchar(500)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자프로필이미지

castType

int(11)

(NULL)

NO

 

2

 

select,insert,update,references

방송형태

castPath

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송매체

exposeOrder

int(11)

(NULL)

NO

 

1

 

select,insert,update,references

노출순서

exposeYN

char(1)

utf8_general_ci

NO

 

Y

 

select,insert,update,references

노출여부

castStartDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송시작일

castEndDate

char(12)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송종료일

episode

int(11)

(NULL)

YES

 

1

 

select,insert,update,references

방송회차

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송로고이미지

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbTopLive

0

PRIMARY

1

castCode

A

1

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbUseCoin  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

userId

varchar(100)

ucs2_general_ci

NO

 

(NULL)

 

select,insert,update,references

시청자아이디

useCoinAmt

varchar(100)

ucs2_general_ci

NO

 

(NULL)

 

select,insert,update,references

사용금액

mcId

varchar(100)

ucs2_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

useDt

char(12)

ucs2_general_ci

NO

 

(NULL)

 

select,insert,update,references

사용일자

useType

varchar(1)

ucs2_general_ci

NO

 

(NULL)

 

select,insert,update,references

사용형태

Indexes

Back

 
tbUser  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

userPwd

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

시청자패스워드

userType

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

시청자형태

nickName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

시청자닉네임

phoneNumber

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

시청자전화번호

userEmail

varchar(100)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

시청자이메일

userProfileImage

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

유저 프로필 이미지

userSex

char(1)

utf8_general_ci

NO

 

0

 

select,insert,update,references

유저 성별

payDate

char(8)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

isOrg

char(1)

utf8_general_ci

YES

 

0

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbUser

0

PRIMARY

1

userId

A

51

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbUserCoin  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

userId

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

시청자아이디

curCoin

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

보유코인

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbUserCoin

0

PRIMARY

1

userId

A

9

(NULL)

(NULL)

 

BTREE

 

 

Back

 
tbVodList  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

vodCode

varchar(100)

utf8_general_ci

NO

PRI

(NULL)

 

select,insert,update,references

vod코드

watchCnt

decimal(10,0)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

시청자수

castDate

char(12)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송일자

castTitle

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송제목

category

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송주제

profileImage

varchar(500)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송프로필이미지

nickName

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자닉네임

castId

varchar(100)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

방송자아이디

castPath

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

방송형태

logoImage

varchar(500)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

방송로고이미지

episode

int(11)

(NULL)

YES

 

1

 

select,insert,update,references

방송회차

isPay

char(1)

utf8_general_ci

NO

 

N

 

select,insert,update,references

유/무료

payAmt

varchar(100)

utf8_general_ci

YES

 

0

 

select,insert,update,references

유료금액

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

tbVodList

0

PRIMARY

1

vodCode

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back