Linkbrary

Tables (7)

Link (링크)

  • link_id (Key) — Long — Primary key — NOT NULL
  • url (String)
  • 세줄요약 (TEXT)
  • 벡터 임베딩 (vector)
  • 본문 (CLOB)
  • 제목 (VARCHAR)

User (유저)

  • user_id (Long) — Long — Primary key — NOT NULL
  • nickname (String) — String
  • email (Field2) — String
  • password (Field3) — String
  • push_notification (Field4) — boolean
  • user_reminder_setting_id (Key) — Long — Foreign key → User_reminder_setting.user_reminder_setting_id — NOT NULL

User_Link (유저_링크)

  • user_link_id (Key2) — Primary key — NOT NULL
  • memo (메모) — String
  • is_open (Field2) — boolean
  • link_id (Key) — Long — Foreign key → Link.link_id — NOT NULL
  • user_id (key) — Long — Foreign key → User.user_id — NOT NULL
  • user_directory_id (Long) — Long — Foreign key → User_directory.user_directory_id — NOT NULL

User_directory (유저 디렉토리)

  • user_directory_id (Long) — Long — Primary key — NOT NULL
  • directory_name (String) — String
  • parent_folder_id (부모 폴더 아이디) — Long
  • created_at (생성시간) — Time
  • modified_at (수정시간) — Time

User_reminder_setting (유저 리마인더 설정)

  • user_reminder_setting_id (Key) — Long — Primary key — NOT NULL
  • unread_alert_time (field) — Time
  • unread_time_alert (Field) — boolean
  • unread_folder_alert (Field2) — boolean
  • unread_folder_alert_count (Field3) — Long

reminder (리마인더(폴더))

  • reminder_id (Key) — Long — Primary key — NOT NULL
  • reminder_time (Field) — time
  • reminder_date (Field2) — List
  • user_directory_id (Long) — Long — Foreign key → User_directory.user_directory_id — NOT NULL

user_link_reminder (리마인더(링크))

  • reminder_id (Key) — Long — Primary key — NOT NULL
  • reminder_time (Field) — time
  • reminder_date (Field2) — List
  • user_link_id (Key2) — Foreign key → User_Link.user_link_id — NOT NULL