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