UYU
Tables (9)
Folder (Untitled4)
- folder_id (Key) — Long — Primary key — NOT NULL
- title (Field2) — String — NOT NULL — 제목
- parent_folder_id (Key3) — Long — Foreign key → Folder.folder_id — NOT NULL
Group (Untitled2)
- group_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String — NOT NULL — 그룹 이름
GroupMember (Untitled7)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- group_id (Key3) — Long — Foreign key → Group.group_id — NOT NULL
Link (Untitled5)
- link_id (Key) — Long — Primary key — NOT NULL
- folder_id (Key2) — Long — Foreign key → Folder.folder_id — NOT NULL
- url (Field) — String — NOT NULL — 링크 url
- content (Field2) — String — 내용
- title (Field4) — String — NOT NULL — 제목
- hit (Field3) — Long — NOT NULL — 조회수-> 나중에 생각
- is_deleted (Field5) — Boolean — NOT NULL — 휴지통
- created_date (Field6) — LocalDateTime — NOT NULL — 생성 날짜
- modified_date (Field7) — LocalDateTime — NOT NULL — 조회 날짜 -> 6월 중 한번도 안보신 링크에요에 사용
- deleted_date (Field8) — LocalDateTime — 삭제 날짜 -> 휴지통 유예기간
LinkTag (Untitled8)
- id (Key) — Primary key — NOT NULL
- link_id (Key2) — Long — Foreign key → Link.link_id — NOT NULL
- tag_id (Key3) — Long — Foreign key → Tag.tag_id — NOT NULL
Member (Untitled)
- member_id (Key) — Long — Primary key — NOT NULL
- email (Field) — String — NOT NULL — 로그인 아이디
- auth_provider (Field2) — String — NOT NULL — Enum값. KAKAO, GOOGLE, NAVER
- is_deleted (Field3) — Boolean — NOT NULL — 회원 탈퇴 여부
Tag (Untitled6)
- tag_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String — NOT NULL — 태그 이름
Token (Untitled3)
- refresh_token (Field2) — String — NOT NULL — jwt 리프레시 토큰
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL — 유저아이디