Calenduck

Tables (5)

DetailInfo (Untitled6)

  • pk (mt20id) — varchar — Primary key — NOT NULL
  • 공연시설id (mt10id) — varchar
  • 공연명 (prfnm) — varchar
  • 공연장소 (fcltynm) — varchar
  • 공연 출연진 (prfcast) — varchar
  • 공연 제작진 (prfcrew) — varchar
  • 런타임 (prfruntime) — varchar
  • 관람연령 (prfage) — varchar
  • 제작사 (entrpsnm) — varchar
  • 티켓가격 (pcseguidance) — varchar
  • 장르 (genrenm) — varchar

Timestamped (Untitled2)

  • 생성시간 (createdAt) — Timestamp
  • 수정시간 (modifiedAt) — Timestamp
  • 삭제시간 (deletedAt) — Timestamp

bookmark (Untitled4)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (user_id) — bigint — Foreign key → users.pk — NOT NULL
  • 공연id (mt20id) — varchar
  • 생성시간 (created_at) — Timestamp
  • 수정시간 (modified_at) — Timestamp
  • 삭제시간 (deleted_at) — Timestamp
  • 메모 (content) — varchar
  • 알람 (alarm) — varchar

namewithmt20id (Untitled3)

  • pk (mt20id) — varchar — Primary key — NOT NULL
  • 출연진 (name) — varchar

users (Untitled)

  • pk (id) — bigint — Primary key — NOT NULL
  • 닉네임 (nickname) — varchar
  • 카카오id (kakao_id) — bigint
  • 이메일 (kakao_email) — varchar
  • 성별 (gender) — varchar
  • 나이 (age) — varchar
  • 권한 (role) — enum