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