Focus

Tables (6)

follow (follower)

  • id (아이디) — bigint — Primary key — NOT NULL
  • follower_id (팔로워 아이디) — bigint — Foreign key → user.id — NOT NULL
  • following_id (팔로잉 아이디) — bigint — Foreign key → user.id — NOT NULL

material (Untitled)

  • id (아이디) — bigint — Primary key — NOT NULL
  • url (링크) — varchar — NOT NULL
  • title (제목) — varchar — NOT NULL

review

  • id (아이디) — bigint — Primary key — NOT NULL
  • user_id (유저 아이디) — bigint — Foreign key → user.id — NOT NULL
  • image_url (이미지 url) — varchar
  • content (내용) — varchar

schedule

  • id (아이디) — bigint — Primary key — NOT NULL
  • user_id (유저 아이디) — bigint — Foreign key → user.id — NOT NULL
  • task (할 일) — varchar — NOT NULL
  • start_time (시작 시간) — datetime — NOT NULL
  • end_time (종료 시간) — datetime — NOT NULL

schedule_connect_material

  • id (아이디) — bigint — Primary key — NOT NULL
  • schedule_id (스케줄 아이디) — bigint — Foreign key → schedule.id — NOT NULL
  • material_id (자료 아이디) — bigint — Foreign key → material.id — NOT NULL

user

  • id (아이디) — bigint — Primary key — NOT NULL
  • nickname (닉네임) — varchar(15) — NOT NULL
  • email (이메일) — varchar — NOT NULL
  • password (비밀번호) — varchar
  • description (설명) — varchar
  • profile (프로필) — varchar