Feature Requirement: Link Input in Note Creation Dialog + Data Model Updates
Component: Note Creation Dialog Feature Name: Link Attachment Inputs Purpose: Allow users to attach up to 10 external links to a note during creation, with full support across database and CSV workflows.

Functional Requirements
Link Input Section
Located near the bottom of the note creation form.

Starts with one Link URL input field.

+ button adds additional fields, up to a maximum of 10.

Each field validates for proper URL format.

Optional: × icon to remove individual link inputs.

Data Handling
Links are stored as part of the note object.

Each note may contain an array of up to 10 link strings.

Links are rendered in note view as clickable anchors.

🗃️ Database Requirements
Notes Table:

Add a new column: note_id (Primary Key, auto-incrementing integer).

Must be globally unique and never recycled, even if a note is deleted.

Used to maintain a strict sequence of note creation.

Add a new column: links (Array of strings or separate normalized table if needed).

Optional Normalization:

If links are stored in a separate table:

Table: note_links

Columns: link_id (PK), note_id (FK), url, position (1–10)

CSV Export Requirements
Exported CSV must include:

note_id (primary key)

note_content

link_1 through link_10 columns (empty if unused)

Link columns must preserve order of entry (e.g., link_1 is the first entered).

CSV Import Requirements
Import must support:

note_id (optional on import; if omitted, system assigns next available ID)

link_1 through link_10 columns

Validation of URL format during import

Rejection or flagging of rows with >10 links