ticketticketchatchat

Tables (16)

Review

  • id — bigint — Primary key — NOT NULL
  • exchagne_id (exchage_id) — bigint — Foreign key → exchange.id — NOT NULL
  • user_id — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • comment — varchar(100)
  • score — int(1)

admin

  • id — varchar(20) — Primary key — NOT NULL
  • pw — varchar(45)
  • nickname — varchar(20)

area

  • id — bigint — Primary key — NOT NULL
  • state — varchar(10)
  • city — varchar(10)

area_contents

  • contents_id — bigint — Foreign key → contents.id — NOT NULL
  • area_id — bigint — Foreign key → area.id — NOT NULL

article

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • topic — varchar(45)
  • text — varchar(100)
  • createdAt — date
  • goodCnt — bigint
  • badCnt — bigint
  • state — boolen
  • replyCnt — bigint

category

  • id — bigint — Primary key — NOT NULL
  • genre — varchar(20) — 스포츠, 음악, 전시 등...
  • detailGenre — varchar(20) — 음악->랩, edm, 종합 스포츠->축구, 배구, 농구, 롤 전시 -> 현대미술, 체험전, 조명전시

contents

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → category.id — NOT NULL
  • name — varchar(20)
  • main — varchar(20)
  • startAt — date
  • endAt — date
  • enterLim — minute

coopon

  • id — bigint — Primary key — NOT NULL
  • admin_id — varchar(20) — Foreign key → admin.id — NOT NULL
  • name — varchar(45)
  • kind — varchar(45)
  • createdAt — date
  • usedAt — date
  • useLim — date
  • discount — int
  • state — boolean

event

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — varchar(20) — Foreign key → admin.id — NOT NULL
  • name (Field) — varchar(45)
  • kind (Field2) — varchar(45)
  • startedAt (Field3) — date
  • endedAt (Field5) — date
  • discount (Field6) — int
  • state (Field7) — boolean

exchange

  • id — bigint — Primary key — NOT NULL
  • user1_id (transferor) — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • user2_id (transferee) — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • ticket_id — bigint — Foreign key → ticket.id — NOT NULL
  • ticketpay_id (ticketpayid2) — varchar(20) — Foreign key → ticketpay.id — NOT NULL
  • form (from) — varchar(20)
  • consentChk — boolean
  • feeChk — boolean
  • rewardChk — boolean
  • exchangedAt — date

reply

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • aritcle_id (article_id) — bigint — Foreign key → article.id — NOT NULL
  • text — varchar(100)
  • createdAt — date
  • goodCnt — bigint
  • badCnt — bigint
  • state — boolen

sit

  • id — bigint — Primary key — NOT NULL
  • ticket_id — bigint — Foreign key → ticket.id — NOT NULL
  • grade — varchar(1)
  • floor — int
  • col — varchar(3)
  • num — int
  • state — boolean

ticket

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • contents_id — bigint — Foreign key → contents.id — NOT NULL
  • admin_id — varchar(20) — Foreign key → admin.id — NOT NULL
  • coopon_id — bigint — Foreign key → coopon.id — NOT NULL
  • seller — varchar(20)
  • createdAt — date
  • payType — varchar(10)
  • price — int
  • cooponChk — boolean
  • eventChk — boolean
  • useableChk — boolean

ticket_event

  • ticket_id (Key3) — bigint — Foreign key → ticket.id — NOT NULL
  • event_id (Key2) — bigint — Foreign key → event.id — NOT NULL

ticketpay

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.id — NOT NULL — ID
  • reward — bigint
  • pay — bigint

user

  • id — varchar(20) — Primary key — NOT NULL — ID
  • area_id — bigint — Foreign key → area.id — NOT NULL
  • pw — varchar(45)
  • nickname — varchar(20)
  • name — varchar(10)
  • email — varchar(45)
  • phone — bigint
  • exchageOpt — boolean
  • payDef — varchar(10)
  • joinType — varchar(10) — 혹은 kakao
  • createdAt — date
  • onlineChk — boolean
  • evgScore — int(1)
  • state — boolean — T이면 활성화 F이면 비활성화