SPTP
Tables (8)
DIARY (다이어리)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- member_id (회원번호) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title (제목) — VARCHAR — NOT NULL
- content (내용) — TEXT — NOT NULL
- date (날짜) — TIMESTAMP — NOT NULL
- weather (날씨) — VARCHAR — NOT NULL — ENUM
- sentiment (기분) — DOUBLE — NOT NULL
- status (공개여부) — TINYINT — NOT NULL — 비공개(0) / 공개(1)
- image_path (이미지 경로) — VARCHAR
FOLLOW (팔로우)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- follower_id (팔로워) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- following_id (팔로잉) — BIGINT — Foreign key → MEMBER.id — NOT NULL
LIKES (추천)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- series_id (시리즈 번호) — BIGINT — Foreign key → SERIES.id — NOT NULL
- member_id (회원번호) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- reg_date (날짜) — TIMESTAMP — NOT NULL
LOCATION (위치)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- schedule_id (일정번호) — BIGINT — Foreign key → SCHEDULE.id — NOT NULL
- latitude (위도) — DOUBLE — NOT NULL
- longitude (경도) — DOUBLE — NOT NULL
- name (장소명) — VARCHAR
MEMBER (회원)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- email (이메일) — VARCHAR — NOT NULL — UNIQUE
- password (비밀번호) — VARCHAR — NOT NULL
- name (별명) — VARCHAR — NOT NULL — UNIQUE
- image_path (이미지 경로) — VARCHAR — NOT NULL
SCHEDULE (일정)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- member_id (회원번호) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- date (일정 날짜) — TIMESTAMP — NOT NULL
- title (제목) — VARCHAR — NOT NULL
- content (내용) — TEXT
SERIES (시리즈)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- member_id (회원번호) — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title (제목) — VARCHAR — NOT NULL
- image_path (이미지 경로) — VARCHAR — NOT NULL
- status (공개여부) — TINYINT — NOT NULL — 비공개(0) / 공개(1)
- view_cnt (조회수) — BIGINT — NOT NULL
- reg_date (날짜) — TIMESTAMP — NOT NULL
SERIES_DIARY (시리즈 아이템)
- id (식별자) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- series_id (시리즈 번호) — BIGINT — Foreign key → SERIES.id — NOT NULL
- diary_id (일기 번호) — BIGINT — Foreign key → DIARY.id — NOT NULL