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