togetherhomt
Tables (13)
Comment (Untitled4)
- comment_id (댓글id) — PK — Primary key — NOT NULL
- feed_id (게시물id) — PK — Foreign key → Feed.user_id — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
- content (내용) — varchar(100)
- created_at (생성일) — date
Copy Of User (CopyOfUntitled)
- user_id (유저id) — PK — Primary key — NOT NULL
- email (이메일) — varchar(50)
- username (유저네임) — varchar(15)
- password (패스워드) — varchar(50)
Feed (Untitled2)
- feed_id (게시물id) — PK — Primary key — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
- title (제목) — varchar(50)
- contents (내용) — text
- created_at (생성일) — date
- media_url (미디어주소) — text
- like_cnt (좋아요수) — long
Like (Untitled5)
- article_id (게시물id) — PK — Foreign key → Feed.feed_id — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
Notification (Untitled11)
- notification_id (알림id) — PK — Primary key — NOT NULL
- from (from유저) — PK — Foreign key → User.user_id — NOT NULL
- to (to유저) — PK — Foreign key → Copy Of User.user_id — NOT NULL
- type (타입) — enum
- time (발신시간) — datetime
User (Untitled)
- user_id (유저id) — PK — Primary key — NOT NULL
- email (이메일) — varchar(50)
- username (유저네임) — varchar(15)
- password (패스워드) — varchar(50)
- introduce (자기소개) — varchar(100)
- profile_url (프로필사진) — text
attendance (Untitled10)
- attendance_id (출석id) — PK — Primary key — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
- performed_date (날짜) — Datetime
- done (출석여부) — boolean
belong (Untitled9)
- group_id (그룹id) — PK — Foreign key → group.group_id — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
exercise (Untitled6)
- exercise_id (운동id) — PK — Primary key — NOT NULL
- type (타입) — enum
- part (부위) — varchar(50)
- name (이름) — varchar(50)
- time (시간) — long
- count (횟수) — long
- video_url (비디오URL) — text
follow (Untitled3)
- from — PK — Foreign key → User.user_id — NOT NULL
- to — PK — Foreign key → Copy Of User.user_id — NOT NULL
group (Untitled8)
- group_id (그룹id) — PK — Primary key — NOT NULL
- main_category (대분류) — varchar(50)
- middle_category (중분류) — varchar(50)
- sub_category (소분류) — varchar(50)
- name (이름) — varchar(50)
record (Untitled7)
- record_id (기록id) — PK — Primary key — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
- exercise_id (운동id) — PK — Foreign key → exercise.exercise_id — NOT NULL
- performed_date (운동날짜시간) — DateTime
today_exercise (CopyOfUntitled7)
- select_id (선택id) — PK — Primary key — NOT NULL
- user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
- exercise_id (운동id) — PK — Foreign key → exercise.exercise_id — NOT NULL
- done (수행여부) — boolean