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)