LookToday

Tables (5)

BriefComment (한줄평)

  • comment_id (한줄평 식별번호) — BIGINT — Primary key — NOT NULL
  • post_id (게시글_식별번호) — BIGINT — Foreign key → Post.post_id — NOT NULL
  • upload_date (작성일) — DATE — NOT NULL
  • user_id (회원 식별번호) — BIGINT — NOT NULL
  • comment (한줄평)

Like (좋아요)

  • post_id (게시글_식별번호) — BIGINT — Foreign key → Post.post_id — NOT NULL
  • user_id (회원 식별번호) — BIGINT — Foreign key → User.user_id — NOT NULL
  • liked_at (좋아요 시간) — TIMESTAMP — NOT NULL

Post (게시글)

  • post_id (게시글_식별번호) — BIGINT — Primary key — NOT NULL
  • user_id (회원 식별번호) — BIGINT — Foreign key → User.user_id — NOT NULL
  • date (날짜) — DATE — Foreign key → WeatherInfo.date — NOT NULL
  • region (지역) — VARCHAR(50) — Foreign key → WeatherInfo.region — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • img_url (사진경로) — VARCHAR(500) — NOT NULL
  • text (글) — TEXT
  • apparent_temp (체감온도) — FLOAT
  • is_public (공개 여부) — BOOLEAN
  • created_at (작성 시간) — TIMESTAMP — NOT NULL
  • updated_at (수정 시간) — TIMESTAMP
  • deleted_At (삭제 시간) — TIMESTAMP

User (회원)

  • user_id (회원 식별번호) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(100) — NOT NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL

WeatherInfo (날씨정보)

  • date (날짜) — DATE — Primary key — NOT NULL
  • region (지역) — VARCHAR(50) — Primary key — NOT NULL
  • user_id (회원 식별번호) — BIGINT — Foreign key → User.user_id — NOT NULL
  • temperature (기온) — FLOAT — NOT NULL
  • humidity (습도) — FLOAT