gongsa
gongsa db erd
Tables (45)
Untitled (notice_header)
- notice number (id) — int — Foreign key → notice_main.notice number — NOT NULL
- category id (category) — int — Foreign key → notice cateogry.category id — NOT NULL
- Field (news_title)
- Field (news_imagePath)
- Field (openDAte)
- Field (open_title)
- Field
Untitled (genre_list)
- Key (name) — varchar — Primary key — NOT NULL
- Field (category) — varchar
Untitled (notice_inside_content)
- notice number (id) — int — Foreign key → notice_main.notice number — NOT NULL
- Field (title) — varchar(100)
- Field (content) — text
- Field (position) — int
after_party
- party number (id) — int — Primary key — NOT NULL
- title — varchar(300)
- estimated time (estTime) — datetime
- capa (capacity) — int
- view count (viewCount) — int
- reply count (replyCount) — int
- regDate — datetime
- place — varchar(400)
- posX — varchar(200)
- posY — varchar(200)
- id (hostUser) — varchar(200) — Foreign key → user_main.id — NOT NULL
after_party_entry
- party number (id) — int — Foreign key → after_party.party number — NOT NULL
- id (userId) — varchar(200) — Foreign key → user_main.id — NOT NULL
badge
- id — int(10) — Primary key — NOT NULL
- name — varchar(300) — NOT NULL
- comment — varchar(500) — NOT NULL
- iconPath — varchar(500)
coupon
- id — int(10) — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- type — varchar(200) — NOT NULL
- value — int
deliberative_list
- deliberative id (id) — int — Primary key — NOT NULL
- user id (userId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- deliberativeDate — date
- notify count (notifyCount) — int
- deliberative status — varchar(30)
event_categories
- category number (id) — int — Primary key — NOT NULL
- category — varchar(100)
event_image_path (board_image_path)
- image path (imagePath) — varchar(200) — Primary key — NOT NULL
- event number (id) — int — Foreign key → event_main.event number — NOT NULL
event_main
- event number (id) — int — Primary key — NOT NULL
- title — varchar(500)
- content — text
- startDate — datetime
- end date (endDate) — datetime
- reg date (regDate) — datetime
- category number (category) — int — Foreign key → event_categories.category number — NOT NULL
- id (adminId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- thumbnail — varchar(500)
- performance info id — int(10) — Foreign key → performance_info.id — 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
- seatRow — char(1) — Primary key
- seatNo — int — Primary key
- hall id (hallId) — int(10) — Foreign key → hall_info_main.id — NOT NULL
- performance id (performanceId) — int(10) — Foreign key → performance_main.id — NOT NULL
- seatRate — char(1)
- seatStatus — char(1)
- mate group (mateGroup) — int(10) — Foreign key → mate_main.id — NOT NULL
mateTimeline (mate_timeline)
- mate (mateId) — int(10) — Foreign key → mate_main.id — NOT NULL
- content — text
- regdate (regDate) — datetime
- user (userId) — varchar(200) — Foreign key → user_main.id — NOT NULL
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) — Foreign key → performance_main.id
- seatGroup — varchar(40) — NOT NULL
- category — int(10) — Foreign key → mate_category.id — NOT NULL
- groupSize — int(1)
- seatrate (seatRate) — char(1) — NOT NULL
mate_members
- userId — varchar(200) — Foreign key → user_main.id — NOT NULL
- id — int(10) — Foreign key → mate_main.id — NOT NULL
mate_tag
- tag — varchar(100) — Primary key — NOT NULL
- id — int(10) — Foreign key → mate_main.id — NOT NULL
message_main
- id — int(10) — Primary key — NOT NULL
- title — varchar(300) — NOT NULL
- content — text — NOT NULL
- sendDate — datetime
- getDate — datetime
- readed — char(1)
- sendUser — varchar(200) — Foreign key → user_main.id
- getUser — varchar(200) — Foreign key → user_main.id
notice badge (notice_badge)
- badge id (id) — int — Primary key — NOT NULL
- badge name (name) — varchar(50)
notice cateogry (notice_categories)
- category id (id) — int — Primary key — NOT NULL
- category name (name) — varchar(300)
notice_image_path
- imagepath (imagePath) — varchar(200) — Primary key — NOT NULL
- notice number (id) — int — Foreign key → notice_main.notice number — NOT NULL
notice_main
- notice number (id) — int — Primary key — NOT NULL
- category id (category) — int — Foreign key → notice cateogry.category id — NOT NULL
- reg date (regDate) — datetime
- id (adminId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- badge id (badge) — int — Foreign key → notice badge.badge id — NOT NULL
- Field (mainTitle) — varchar(100)
notify (notify_list)
- notifiedUser — varchar(200) — Primary key — NOT NULL
- notifyUser — varchar(200) — Foreign key → user_main.id — NOT NULL
- notifyDate — date
- notifyReason (reason) — text
- notifyCategory (category) — int — Foreign key → notify_category.category_no — NOT NULL
notify_category (notify_categories)
- category_no (id) — int — Primary key — NOT NULL
- category — varchar(200)
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)
performance_genre
- genre name (genre) — varchar(30) — Primary key — NOT NULL
- id — int(10) — Foreign key → performance_info.id — NOT NULL
performance_info
- id — int(10) — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- category — varchar(200) — NOT NULL
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- rating — int(11) — NOT NULL — 관람등급
- runningTime — time — 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
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
- showSchedule (showDate) — date — NOT NULL
- Field (showTime) — time
- show number (showNumber) — int
profile icon (profile_icon)
- iconId (id) — int — Primary key — NOT NULL
- icon path (path) — varchar(500)
- icon name (name) — varchar(30)
- icon category (category) — varchar(50)
qna _category (qna_category)
- category no (id) — int — Primary key — NOT NULL
- category — varchar(200)
qna_image_path
- image path (imagePath) — varchar(300) — Primary key — NOT NULL
- qna number (id) — int — Foreign key → qna_main.qna number — NOT NULL
qna_main
- qna number (id) — int — Primary key — NOT NULL
- questionTitle — varchar(200)
- user (userId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- question content (questionContent) — text
- answer content (answerContent) — text
- admin (adminId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- reg date (regDate) — datetime
- category no (category) — int — Foreign key → qna _category.category no — NOT NULL
- opened — char(1)
- answer title (answerTitle) — varchar(200)
reserve_main
- id — int(10) — Primary key — NOT NULL
- reserveUser — varchar(200) — Foreign key → user_main.id
- performanceId — int(10) — Foreign key → performance_main.id
- regdate — datetime
- Status — varchar(50) — NOT NULL
- recive type (receiveType) — varchar(40)
- id (mateid) — int(10) — Foreign key → mate_main.id — NOT NULL
user_address
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- postalCode — int(11)
- sido — varchar(200)
- sigungu — varchar(300)
- addr — varchar(400)
user_badge
- badgeId — int(10) — Foreign key → badge.id — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- opened — char(1)
user_black_list
- black — varchar(200) — Primary key — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- regdate (regDate) — datetime
user_coupon
- couponId — int(10) — Foreign key → coupon.id — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- get date (getDate) — datetime
user_follow
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- following — varchar(200) — Foreign key → user_main.id — NOT NULL
user_interest
- interestTag — varchar(200) — Primary key — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
user_intro
- tagNo — int(10) — Primary key — NOT NULL
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- introTag — varchar(300) — NOT NULL
user_likes
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- performanceId — int(10) — Foreign key → performance_info.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 (userId) — varchar(200) — Foreign key → user_main.id — NOT NULL
- point change (point) — int
- status — varchar(30)
- regDate — datetime
- id — int(10) — Foreign key → payment_main.id — NOT NULL
user_sub
- id — varchar(200) — Foreign key → user_main.id — NOT NULL
- regDate — datetime
- deleted — char(1)
- point — int(11)
- getLike — int(11)
- getNotify — int(11)
- iconId — int — Foreign key → profile icon.iconId — NOT NULL
- grade — varchar(50)
- total point (totalPoint) — int
- shutout — char(1)