~h.dddddddddd d d d d dddddddddddddd dddddd d!d"d#d$d%d&d'd d(d)d*d+d,d-d.d/d0d1d2d3d4d d5d6d7d8d9d:d;dd?d@dAd dBdCdDdEdFdGdHdIdJdKdLdMdNd dOdPdQdRdSdTdUdVdWdXdYdZd[d d\d]d^d_d`dadbdcdddedfdgdhd didjdkdldmdndodpdqdrdsdtdud dvdwdxdydzd{d|d}d~ddddd g Zddddddddddddddddddddddddkdddd(ddddddddd5ddddddd5dgZiddddddddddddddddddddddddddddddddddidddddddddddddddd“ddÓddddēddœddddƓddǓddddiddddddȓddɓddʓdd˓dd̓dd͓ddΓddddϓddГddddѓddǓddddidd(dd(ddғddӓddԓddՓdd֓ddדddؓddddٓddړddddۓddǓddddidd5dd5ddܓddݓddޓddߓddddddddddddddddddǓddddiddBddBddddddddddddddddddddddddddǓddddiddOddOddddddddddddddddddddddddddǓdd(ddidd\dd\ddddddddddddddddddddddddddǓdd(ddiddiddidddddddddddddd dddd dd dddd ddǓdd5ddiddvddvdd ddӓddddddddddddddddddddddǓdd5ddg Zy(z 2026-01-01zTech Solutions LtdTS001z123 Main St, New York, USAz Alice Johnsonzalice@techsolutions.comz+1-555-111-2222z Bob Williamszbob@techsolutions.comz+1-555-333-4444z 2025-01-01zTS-{year}-{clientCode}) company_idlicenceValidUntil companyName clientCodeaddress pAdminName pAdminEmail pAdminMobil sAdminName sAdminEmail sAdminMobillicenceDateIssuedcertificateNameFormatz 2026-03-15zGreen Energy CorpGE002z45 Solar Rd, Austin, USAz Charlie Brownzcharlie@greenenergy.comz+1-555-222-3333z Diana Princezdiana@greenenergy.comz+1-555-444-5555z 2025-03-15zGE-{year}-{clientCode}z 2026-05-10zHealthCare SystemsHC003z78 Wellness Ave, Chicago, USAz Ethan Clarkzethan@healthcare.comz+1-555-333-6666z Fiona Greenzfiona@healthcare.comz+1-555-777-8888z 2025-05-10zHC-{year}-{clientCode}z 2026-07-20zEduSmart Pvt LtdES004z101 Learning Blvd, Boston, USAz George Harriszgeorge@edusmart.comz+1-555-444-9999z Hannah Leezhannah@edusmart.comz+1-555-111-0000z 2025-07-20zES-{year}-{clientCode}z 2026-09-05z AutoDrive IncAD005z222 Drive Ln, Detroit, USAz Ian Wrightzian@autodrive.comz+1-555-555-1111z Julia Kingzjulia@autodrive.comz+1-555-222-2222z 2025-09-05zAD-{year}-{clientCode}z 2026-11-11z Foodies WorldFW006z!56 Gourmet St, San Francisco, USAz Kevin Scottzkevin@foodiesworld.comz+1-555-666-3333z Laura Whitezlaura@foodiesworld.comz+1-555-999-5555z 2025-11-11zFW-{year}-{clientCode}z 2027-01-30zFinTech GlobalFG007z789 Finance Way, Miami, USAz Michael Brownzmichael@fintech.comz+1-555-777-6666z Natalie Adamsznatalie@fintech.comz+1-555-333-7777z 2026-01-30zFG-{year}-{clientCode}z 2027-03-22zCloudNet ServicesCN008z456 Sky Dr, Seattle, USAz Oliver Daviszoliver@cloudnet.comz+1-555-888-2222z Paula Greenzpaula@cloudnet.comz+1-555-444-8888z 2026-03-22zCN-{year}-{clientCode} z 2027-06-18 TravelXploreTX009z654 Adventure Rd, Denver, USAz Quentin Hallzquentin@travelxplore.comz+1-555-111-6666z Rachel Woodzrachel@travelxplore.comz+1-555-222-8888z 2026-06-18zTX-{year}-{clientCode} z 2027-08-01zSmartBuild ConstructionsSB010z321 Builder Ave, Dallas, USAz Steven Youngzsteven@smartbuild.comz+1-555-333-9999z Tina Brooksztina@smartbuild.comz+1-555-444-1111z 2026-08-01zSB-{year}-{clientCode}zOcean ExplorerCargo IMO1234567zISO-9001zMarine Logistics LtdML001) vessel_id vesselName vesselTypeimovesselStandars sisterCompany companyCode companyIdz Sea VoyagerTanker IMO2345678z ISO-14001zGlobal Shipping CorpGS002z Wave Rider Passenger IMO3456789SOLASTX003zArctic Carrier IMO4567890z ISO-45001zPolar LogisticsPL004z Marine SpiritResearch IMO5678901MARPOLzOceanic Research OrgOR005 seafarer_idroleIdRolez Master & C/O firstNameJohnlastNameSmith middleNameAemailzjohn.smith@example.compassword hashed123mobilez+1-555-101-0001idTypeidNumberP1234567idIssueCountryUSAshipName onboardDatez2025-09-01T10:00:00Z isCaptainYesvesselIdstatusActivez 2/O & 3/OAliceJohnsonBzalice.j@example.com hashed234z+1-555-101-0002P2345678UKz2025-09-05T10:00:00ZNoz C/E & 2/EMichaelBrownCzmichael.b@example.com hashed345z+1-555-101-0003ID789123Canadaz2025-09-10T10:00:00Zz 3/E & 4/ESophiaTaylorDzsophia.t@example.com hashed456z+1-555-101-0004P5678901 Australiaz2025-09-12T10:00:00Zz*Electrician, Ref & Gas Engineer, and OtherDavidWilsonEzdavid.w@example.com hashed567z+1-555-101-0005ID987654Indiaz2025-09-15T10:00:00Zz Deck RatingEmmaDavisFzemma.d@example.com hashed678z+1-555-101-0006P4567890 Philippinesz2025-09-18T10:00:00Zz Engine RatingLiamMartinezGzliam.m@example.com hashed789z+1-555-101-0007P7894561Mexicoz2025-09-20T10:00:00ZOliviaGarciaHzolivia.g@example.com hashed890z+1-555-101-0008ID112233Spainz2025-09-22T10:00:00ZzGeneral Supts.JamesAndersonIzjames.a@example.com hashed901z+1-555-101-0009P6543210Germanyz2025-09-24T10:00:00ZzChief EngineerClarkJzsophia.c@example.com hashed012z+1-555-101-0010ID445566Norwayz2025-09-26T10:00:00ZN) companiesvessels seafarers4/var/www/html/beaconod-api/app/utils/common_utils.pyrs  %'+!,$ *$%5 %&)!,$ *$%5%'.)$)$%5 %%/!($($%5 %"+&$($%5 %"2+$+$%5 %#,!($!($%5 %&) ($'$%5 %!. -$,$%5 %-- *$($%5QW  z&$/ #%/ "!!' &%* % "/ S3 tq!  V  G  c  ) K # ! J % $ - U A!" (#&q!   W  I  c  & K # ! J $ $ - T A!" (#&q!   Y  G  c  ( K # ! J ( M - T A!" (#&q!   X  H  c  ' K # ! J + M - T A!" (#&q! < W  H  c  & K # ! J ' L - T A!" (#&q!   V  G  c  % K # ! J - L - T A!" (#&q!  V  J  c  % K # ! J ( $ - T A!" (#&q!  X  H  c  ' K # ! J ' $ - T A!" (#&q!   W  J  c  & K # ! J ) O - T A!" (#&r"   X  G  c  ' K # ! J ( O - T A!" (#Y@  r