2024_DANPOONG_TEAM_27_FE
Tables (4)
Fortune (운세)
- fortune_id (운세ID) — BIGINT — Primary key — NOT NULL
- user_id (유저ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- name (이름) — VARCHAR
- date (날짜) — LOCALDATE
- description (설명) — VARCHAR
- Field
Goal (목표)
- goal_id (목표ID) — BIGINT — Primary key — NOT NULL
- user_id (유저ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- name (이름) — VARCHAR
- isCompleted (달성여부) — BOOLEAN
- start_date (시작날짜) — LOCALDATE
- end_date (종료날짜) — LOCALDATE
Todo (할일)
- todo_id (할일ID) — BIGINT — Primary key — NOT NULL
- goal_id (목표ID) — BIGINT — Foreign key → Goal.goal_id — NOT NULL
- name (이름) — VARCHAR
- isCompleted (완료여부) — BOOLEAN
User (사용자)
- user_id (유저ID) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- profileImage (사진) — VARCHAR
- nickname (닉네임) — VARCHAR
- gender (성별) — VARCHAR
- date_of_birth (생년월일) — LOCALDATETIME