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이면 비활성화