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