looktoday

Tables (5)

image (코디 이미지)

  • image_id (이미지 식별번호) — bigint — Primary key — NOT NULL — auto_increment
  • imgUrl (이미지 Url) — VARCHAR(1000) — NOT NULL
  • looktoday_id (룩투데이 식별번호) — bigint — Foreign key → post.looktoday_id — NOT NULL — auto_increment

likes (좋아요)

  • id (식별번호) — biginy — Primary key — NOT NULL — auto_increment
  • looktoday_id (룩투데이 식별번호) — bigint — Foreign key → post.looktoday_id — NOT NULL — auto_increment
  • user_id (사용자 식별번호) — bigint — Foreign key → user.user_id — NOT NULL — auto increment

post (룩투데이)

  • looktoday_id (룩투데이 식별번호) — bigint — Primary key — NOT NULL — auto_increment
  • user_id (사용자 식별번호) — bigint — Foreign key → user.user_id — NOT NULL — auto increment
  • date (날짜) — timestamp — NOT NULL
  • si (Field)
  • gungu (Field2)
  • apparent_temp (체감온도) — enum — NOT NULL
  • apparent_humidity (체감습도) — enum — NOT NULL
  • weather (날씨 아이콘) — enum — NOT NULL
  • isPublic (공개여부) — boolean — NOT NULL
  • comment (코디 한 줄 평가) — VARCHAR(40)

user (사용자)

  • user_id (사용자 식별번호) — bigint — Primary key — NOT NULL — auto increment
  • email (이메일) — VARCHAR(200) — NOT NULL
  • password (비밀번호) — VARCHAR(100)
  • nickname (닉네임) — VARCHAR(15) — NOT NULL
  • birth (생년월일) — date — 년도, 월, 일만 나타내게
  • si (시(지역)) — NOT NULL
  • gungu (군구(지역)) — NOT NULL

weather (날씨 정보)

  • looktoday_id (룩투데이 식별번호) — bigint — Foreign key → post.looktoday_id — NOT NULL — auto_increment
  • Field