Jewelry category fields
| Field | Type | Options / Notes |
|---|---|---|
| Jewelry Type | Dropdown | Options: Ring, Engagement Ring, Wedding Band, Necklace, Pendant, Choker, Chain, Collar, Locket, Bracelet, Bangle, Cuff, Tennis Bracelet, Charm Bracelet, Earrings (pierced), Earrings (clip), Earrings (screw-back), Brooch/Pin, Bar Pin, Stick Pin, Hair Pin/Comb, Tiara/Crown, Cufflinks, Tie Pin/Clip, Chatelaine, Suite/Parure, Demi-Parure, Other |
| Period/Era | Dropdown | Options: Georgian (1714-1837), Victorian Early (1837-1860), Victorian Mid (1860-1885), Victorian Late (1885-1901), Arts & Crafts, Art Nouveau, Edwardian (1901-1915), Art Deco (1920-1935), Retro (1935-1950), Mid-Century (1950-1970), Modernist, Contemporary, Estate (unknown period), Other |
| Designer/Maker | Text | Designer/Maker |
| Brand/House | Text | Brand/House |
| Country of Origin | Text | Country of Origin |
| Primary Metal | Dropdown | Options: Platinum, 18K Gold, 14K Gold, 10K Gold, 9K Gold, 22K Gold, 24K Gold, White Gold, Rose Gold, Yellow Gold, Sterling Silver, 800 Silver, 950 Silver, Vermeil, Gold Filled, Gold Plated, Rolled Gold, Silver Plated, Palladium, Mixed Metals, Costume/Base Metal, Other |
| Metal Purity/Fineness | Text | Metal Purity/Fineness |
| Hallmarks | Textarea | Hallmarks and identifying marks |
| Secondary Metal | Text | Secondary Metal |
| Primary Gemstone | Text | Primary Gemstone |
| Secondary Gemstones | Textarea | Secondary gemstones and details |
| Signed/Marked | Dropdown | Options: Signed, Maker's Mark, Hallmarked, Numbered, Unsigned |
| Mark Details | Textarea | Details about marks and signatures |
| Overall Condition | Dropdown | Options: Excellent, Very Good, Good, Fair, Poor |
| Metal Condition | Dropdown | Options: Excellent, Good, Scratched, Dented, Worn, Bent |
Advanced fields (Premium-only)
Gemstone Details
| Field | Type | Options / Notes |
|---|---|---|
| Stone Type | Dropdown | Options: Diamond, Ruby, Sapphire, Emerald, Pearl, Opal, Amethyst, Aquamarine, Citrine, Garnet, Peridot, Topaz, Tourmaline, Tanzanite, Turquoise, Jade, Coral, Amber, Onyx, Moonstone, Morganite, Alexandrite, Spinel, Chrysoberyl, Zircon, Lab-Created, Simulated, Other |
| Number of Stones | Number | Number of stones |
| Total Carat Weight | Text | Total carat weight |
| Center Stone Weight | Text | Center stone weight |
| Stone Shape/Cut | Dropdown | Options: Round Brilliant, Princess, Cushion, Oval, Emerald Cut, Pear, Marquise, Radiant, Asscher, Heart, Trillion, Baguette, Rose Cut, Old Mine Cut, Old European Cut, Single Cut, Cabochon, Carved, Briolette, Fancy, Mixed |
| Stone Color | Text | Stone color |
| Stone Clarity | Dropdown | Options: FL, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, I1, I2, I3, Eye Clean, Included, Not Applicable |
| Color Grade (diamonds) | Dropdown | Options: D, E, F, G, H, I, J, K, L, M, N-Z, Fancy Color, Not Graded |
| Stone Origin | Text | Geographic origin if known |
| Stone Treatment | Dropdown | Options: None/Natural, Heat Treated, Fracture Filled, Oiled, Irradiated, Coated, Diffused, Laser Drilled, Unknown |
| Certification | Dropdown | Options: GIA, AGS, EGL, IGI, HRD, Other Lab, None |
| Certificate Number | Text | Certificate number |
Pearl Details
| Field | Type | Options / Notes |
|---|---|---|
| Pearl Type | Dropdown | Options: Natural, Akoya (cultured), South Sea (cultured), Tahitian (cultured), Freshwater (cultured), Keshi, Mabe, Baroque, Seed Pearl, Simulated |
| Pearl Shape | Dropdown | Options: Round, Near-Round, Oval, Button, Drop, Baroque, Circle, Keshi |
| Pearl Color | Text | Pearl color |
| Pearl Size | Text | Diameter in mm |
| Pearl Luster | Dropdown | Options: Excellent, Very Good, Good, Fair, Poor |
| Pearl Surface | Dropdown | Options: Clean, Lightly Blemished, Moderately Blemished, Heavily Blemished |
| Nacre Quality | Dropdown | Options: Excellent, Good, Fair, Thin |
| Strand Length | Text | For necklaces |
| Number of Pearls | Number | Number of pearls |
| Matching | Dropdown | Options: Excellent, Good, Fair, Poor |
Designer & Signed Jewelry
| Field | Type | Options / Notes |
|---|---|---|
| Designer/House | Text | Designer/House |
| Collection/Line | Text | Collection/Line |
| Design Name | Text | Design Name |
| Reference Number | Text | Reference Number |
| Year Introduced | Text | Year Introduced |
| Year Retired | Text | Year Retired |
| Signature Location | Text | Signature Location |
| Signature Type | Dropdown | Options: Engraved, Stamped, Plaque, Tag |
| Original Box | Boolean |
|
| Original Papers | Boolean |
|
| Certificate of Authenticity | Boolean |
|
| Provenance | Textarea | Detailed provenance information |
Construction Details
| Field | Type | Options / Notes |
|---|---|---|
| Construction Method | Dropdown | Options: Hand-Fabricated, Cast, Die-Struck, Machine-Made, Mixed |
| Setting Type | Dropdown | Options: Prong, Bezel, Channel, Pavé, Invisible, Flush/Gypsy, Tension, Cluster, Halo, Not Applicable |
| Prong Count | Number | Number of prongs |
| Closure Type | Dropdown | Options: Lobster Claw, Spring Ring, Toggle, Box Clasp, Barrel, Fishhook, Lever Back, Push Back, Omega Back, Screw Back, Clip, Hinged, Pin Stem, None |
| Safety Features | Textarea | Safety catch, figure-8, etc. |
| Articulated | Boolean |
|
| Convertible | Boolean |
|
| Enamel Work | Dropdown | Options: None, Cloisonné, Champlevé, Plique-à-Jour, Guilloché, Painted, Basse-Taille |
| Enamel Condition | Dropdown | Options: Excellent, Good, Minor Loss, Moderate Loss, Significant Loss, Not Applicable |
Condition Details
| Field | Type | Options / Notes |
|---|---|---|
| Scratches | Dropdown | Options: None, Light, Moderate, Deep |
| Dents/Dings | Dropdown | Options: None, Minor, Moderate, Significant |
| Wear | Dropdown | Options: None, Light, Moderate, Heavy |
| Plating Condition | Dropdown | Options: Excellent, Good, Worn, Flaking, Needs Replating, Not Applicable |
| Stone Condition | Dropdown | Options: Excellent, Good, Chips, Scratches, Cracks, Inclusions, Abraded |
| Stone Issues | Textarea | Detailed stone condition issues |
| Missing Stones | Dropdown | Options: None, One, Few, Several, Many |
| Loose Stones | Boolean |
|
| Prong Condition | Dropdown | Options: Excellent, Good, Worn, Bent, Missing, Not Applicable |
| Clasp Function | Dropdown | Options: Fully Functional, Needs Adjustment, Not Functional, Not Applicable |
| Chain Condition | Dropdown | Options: Excellent, Good, Kinked, Broken Links, Not Applicable |
| Repairs | Textarea | Details of repairs and restoration |
| Sizing | Text | Ring size, bracelet length, etc. |
| Resized | Dropdown | Options: Original Size, Enlarged, Reduced, Unknown |
Provenance & History
| Field | Type | Options / Notes |
|---|---|---|
| Provenance Type | Dropdown | Options: Original Owner, Family Heirloom, Estate, Auction, Dealer, Retail, Celebrity/Notable, Unknown |
| Provenance Details | Textarea | Detailed provenance information |
| Previous Owners | Textarea | Information about previous owners |
| Celebrity/Notable Association | Textarea | Celebrity or notable person associations |
| Historical Significance | Textarea | Historical significance and context |
| Auction History | Textarea | Previous auction sales and results |
| Original Receipt | Boolean |
|
| Appraisal History | Textarea | Previous appraisals and valuations |