GigaLive |
tbAccumWatch
tbAd
tbBlackList
tbCategory
tbCategoryPeople
tbFavorite
tbFilterText
tbLiveList
tbManager
tbMCList
tbPayedLog
tbScheduledLive
tbSubscribe
tbTopBanner
tbTopLive
tbUseCoin
tbUser
tbUserCoin
tbVodList
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