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 — 유저아이디

remind (Untitled9)