GONGSA_DB
Tables (33)
coupon
- id — int(10) — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- type — varchar(200) — NOT NULL
- value — int(11)
genres
- name — varchar(40) — Primary key — NOT NULL
- category — varchar(200) — Primary key — NOT NULL
hall_info_main
- id — int(10) — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- address — varchar(200) — NOT NULL
- gpsX — varchar(200) — NOT NULL
- gpsY — varchar(200) — NOT NULL
hall_seats
- seatBlock — char(1) — Primary key — NOT NULL
- seatRow — int(10) — Primary key — NOT NULL
- seatCol — int(10) — Primary key — NOT NULL
- seatRate — char(1) — Primary key — NOT NULL
- mateGroup — int(11) — Primary key — NOT NULL
- hallId — int(10) — Foreign key → hall_info_main.id — NOT NULL
- performanceId — int(10) — Foreign key → performance_main.id — NOT NULL
- seatStatus — char(1)
images
- category — varchar(100) — Primary key — NOT NULL
- imagePath — varchar(100) — Primary key — NOT NULL
- date — datetime
mate_category
- id — int(10) — Primary key — NOT NULL
- category — varchar(100) — NOT NULL
mate_main
- id — int(10) — Primary key — NOT NULL
- performanceId — int(10)
- seatGroup — varchar(40) — NOT NULL
- category — int(10) — Foreign key → mate_category.id — NOT NULL
- groupSize — int(1)
- seatRate — char(1) — NOT NULL
- status — varchar(50)
- groupCnt — int(1)
mate_members
- userId — varchar(200) — Primary key — NOT NULL
- id — int(10) — Foreign key → mate_main.id — NOT NULL
- performanceId — int(11) — Foreign key → performance_main.id
mate_tag
- tag — varchar(100) — NOT NULL
- id — int(10) — Foreign key → mate_main.id — NOT NULL
- performanceId — int(11) — Foreign key → performance_main.id
mate_timeline
- mateId — int(10) — Foreign key → mate_main.id — NOT NULL
- content — text
- regDate — datetime
- userId — varchar(200) — NOT NULL
- performanceId — int(11) — Foreign key → performance_main.id
notice_badge
- id — int(11) — Primary key — NOT NULL
- name — varchar(50)
notice_categories
- id — int(11) — Primary key — NOT NULL
- name — varchar(300)
notice_image_path
- imagePath — varchar(200) — Primary key — NOT NULL
- id — int(11) — Foreign key → notice_main.id — NOT NULL
notice_inside_content
- id — int(11) — Foreign key → notice_main.id — NOT NULL
- title — varchar(100)
- content — text
- position — int(11) — NOT NULL
notice_main
- id — int(11) — Primary key — NOT NULL
- title — varchar(500)
- category — int(11) — Foreign key → notice_categories.id
- regDate — datetime
- adminId — varchar(200) — Foreign key → user_main.id — NOT NULL
- badge — int(11) — Foreign key → notice_badge.id
- hits — int(11)
- imoticon — varchar(50)
- deleted — char(1)
payment_main
- id — int(10) — Primary key — NOT NULL
- reserveId — int(10) — Foreign key → reserve_main.id — NOT NULL
- pay — int(10) — NOT NULL
- method — varchar(50) — NOT NULL
- regDate — datetime
- usedPoint — int(10)
- split — int(11)
- couponValue — int(11)
performance_genre
- id — int(10) — Foreign key → performance_info.id — NOT NULL
- genre — varchar(30) — Foreign key → genres.name — NOT NULL
performance_info
- id — int(10) — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- category — varchar(200) — NOT NULL
- startDate — date — NOT NULL
- endDate — date — NOT NULL
- rating — int(11) — NOT NULL — 관람등급
- runningTime — varchar(200) — NOT NULL
- provider — varchar(200) — NOT NULL
- point — double — NOT NULL
- likes — int(11) — NOT NULL
- imagePath — varchar(200) — NOT NULL
- explain — longtext — NOT NULL
- hallInfoId — int(11) — Foreign key → hall_info_main.id
- reserveCount — int(11)
performance_main
- id — int(10) — Primary key — NOT NULL
- infoId — int(10) — Foreign key → performance_info.id — NOT NULL
- hallId — int(10) — Foreign key → hall_info_main.id — NOT NULL
- showDate — date — NOT NULL
- showTime — varchar(100) — NOT NULL
- showNumber — int(11) — NOT NULL
- registeredDate — datetime
performance_seat_price
- seatRate — char(1) — Primary key — NOT NULL
- infoId — int(11) — Foreign key → performance_info.id — NOT NULL
- price — int(10)
qna_category
- id — int(11) — Primary key — NOT NULL
- category — varchar(200)
qna_image_path
- imagePath — varchar(200) — Primary key — NOT NULL
- id — int(11) — Foreign key → qna_main.id — NOT NULL
qna_main
- id — int(11) — Primary key — NOT NULL
- questionTitle — varchar(200) — NOT NULL
- userId — varchar(200) — Foreign key → user_main.id — NOT NULL
- questionContent — text — NOT NULL
- answerContent — text
- adminId — varchar(200)
- regDate — datetime — NOT NULL
- category — int(11) — Foreign key → qna_category.id — NOT NULL
- opened — char(1) — NOT NULL
- answerTitle — varchar(200)
- answerDate — datetime
- hits — int(11)
- deleted — char(1)
reserve_main
- id — int(10) — Primary key — NOT NULL
- reserveUser — varchar(200) — NOT NULL
- performanceId — int(10) — Foreign key → performance_main.id
- regDate — datetime
- status — varchar(50) — NOT NULL
- receiveType — varchar(40)
- mateId — int(10) — Foreign key → mate_main.id
- seatRate — char(1)
user_address
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- postalCode — varchar(50)
- sido — varchar(200)
- sigungu — varchar(300)
- addr — varchar(400)
user_coupon
- couponId — int(10) — Foreign key → coupon.id — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- getDate — datetime
- used — char(1) — NOT NULL
- expDate — date
user_interest
- interestTag — varchar(200) — Primary key — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- interestCategory — varchar(100) — NOT NULL
user_intro
- introTag — varchar(100) — Primary key — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
user_like_user
- likeUser — varchar(200) — Foreign key → user_main.id — NOT NULL
- likedUser — varchar(200) — Foreign key → user_main.id — NOT NULL
user_likes
- infoId — int(10) — Foreign key → performance_info.id — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
user_main
- id — varchar(200) — Primary key — NOT NULL
- password — varchar(400) — NOT NULL
- nickname — varchar(200) — NOT NULL
- birthday — date — NOT NULL
- gender — char(1)
- email — varchar(500) — NOT NULL
- tel — varchar(100)
- admin — char(1)
user_point_history
- id — int(11) — Primary key — NOT NULL
- paymentId — int(11) — Foreign key → payment_main.id — NOT NULL
- userId — varchar(200) — Foreign key → user_main.id — NOT NULL
- regDate — datetime
- status — varchar(30)
- value — int(11)
user_sub
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- regDate — datetime
- deleted — char(1) — NOT NULL
- point — int(11)
- getLike — int(11)
- getNotify — int(11)
- grade — varchar(50)
- totalPoint — int(11)
- shutout — char(1) — NOT NULL