dd

Tables (5)

Calendar (일정 등록(직접))

  • calendar_id (일정id) — integer — Primary key — NOT NULL
  • title (제목) — varchar
  • calendar_date (날짜) — date
  • calendar_type (일정 타입) — varchar
  • content (내용) — varchar
  • post_id (게시글id) — integer — Foreign key → Post.post_id — NOT NULL

Image (이미지)

  • post_id (게시글id) — integer — Foreign key → Post.post_id — NOT NULL
  • image_info (본문 이미지 링크) — varchar
  • image_link (이미지 링크) — varchar

Like_List (좋아요 리스트)

  • like_id (좋아요 id) — integer — Primary key — NOT NULL
  • post_id (좋아요 누른 게시글id) — integer — Foreign key → Post.post_id — NOT NULL

Notification (알람)

  • notification_id (알림id) — integer — Primary key — NOT NULL
  • notification_date (날짜) — date
  • notification_time (시분초) — time
  • calendar_id (일정id) — integer — Foreign key → Calendar.calendar_id — NOT NULL

Post (게시글)

  • post_id (게시글id) — integer — Primary key — NOT NULL
  • title (제목) — varchar
  • start_date (시작일) — date
  • end_date (종료일) — date
  • ongoing (전시중) — boolean
  • region (지역) — varchar
  • price (관람료) — integer
  • link (링크) — varchar
  • author_name1 (작가명) — varchar
  • author_name2 (그 외 작가) — varchar
  • description (설명) — text
  • location (장소) — varchar
  • address (주소) — varchar
  • like (좋아요) — boolean