Happy Birthday Traveller

A day past the 40th anniversary we played the last round in my current game. The good doctor Boris is doing a larger loop around the Trojan Reach before returning (possibly) to Glisten, and our young Scout, accompanied by Li as his engineer, is returning to Cyan to get his ship fixed as well as report on what happened.

I pretty much soft pedaled the adventure - originally I was thinking the Katydid would not be able to even launch, thus fixing the issue with 2 players and having 2 ships. However, as things worked out with real life, the plan changed a bit.

The Katydid was downed by an EMP, creating an impact crater on Selshor. The planet having a very thin atmosphere meant that the ship was almost safe from the local TL 6 governments. Between the high altitude requiring extensive equipment to live, and an almost impervious crystaliron hull, the ship, while scuffed and marked with repeated attempts to enter, was still safe and sound.

The first trip was a scouting trip to see how bad things were.  Using a probe to create ECM, the ship's pinnace landed nearby and Travis, Francine and Ferdinando got into the ship. They had a few minutes before the local government forces arrived from their base camp a couple of kilometers away.  They managed to get the ships logs and do a quick engineering survey and found that the ship was damaged but that they could probably repair it.

Another day in orbit, and Travis, Ferdinando and Boris return to the ship. They get enough fuel to get the Katydid to orbit, and start on the repairs. The local goons show up, waving submachine guns, but they are unable to get in or do any damage to the ship. Additionally, the local forces only have a couple of hours of air before having to return to the base camp.

It takes another full day to repair the Katydid enough to get her into orbit, along with the daily display of impotent machismo from the local government. Finally everything is as ready as they can make it. Travis starts up the engines, and they sputter. Assuming a fusion plant can  sputter....In the meantime, Le Suroit mentions that another crawler has just reached the plateau, hauling what appears to be a howitzer of some sort. As the terrain is unforgiving, and the crawlers are slow, they do have some time. Which they needed - it was the third attempt that finally got the Katydid launched, and moments later they matched high orbits with Le Suroit.

A few days of additional repairs, and the two ships parted ways, and we pretty much finished the mini campaign.

Last Traveller Sunday

The upcoming Traveller Sunday may be the last - one of my players is dropping out.  Hopefully due to other things in real life versus just not enjoying the game.  Sometimes it is hard to tell.

The Selshor system is a red zone system. The primary reason, outside of being outside the Imperium, is the rabidly xenophobic residents. Yes, another xenophobic planet, but at least this one is not a dictatorship - it is a balkanized world (well, one of the governments could be a dictatorship).

It is a small planet with deep crevasses where the population lives in one of 3 major or a few of the smaller valleys where the air is merely thin versus very thin. Most of the planet is high plateaus, which is where the Katydid, Travis' Scout ship, crashed down.  The reasons are not yet known as to why the ship crashed, and the Scout that managed to escape, one of the scientists aboard Le Suroit, has only hazy recollections other than an almost dire fear of the planet itself.

During the week in jump, between research on Girly Girl the Lord Fish and trying to study up on astrogation, the Travellers learn what they can about Selshor.  Beyond the physical information on the system (11 planets and a planetoid belt, 3 gas giants) not much is known about the actual population. The last ISS survey as 11 years ago and apparently they did not get too close to the population at the time. It is estimated that there are about 800-900,000 people, all human, split into 3 major population centers in 3 different canyons that support human life.  The planet is a desert planet with no surface water, although there must be underground water for the nearly 1 million residents.

Traveller Sunday

We sped through a couple of planets: Candia was a desert planet ruled by yet another dictator. Le Suroit stopped by the gas giant, made a few wilderness runs with Travis learning to fly the pinnace, the regular maintenance by the engineers, a very successful research roll, then on to the next system. T'yana is a rich garden world.  Travis and Li restocked with fresh produce as well as frozen and packaged supplies while the pinnace made a few trips reloading fuel and cargo.  There was yet another very successful research roll, so Dr. Boris is making headway on the Lord Fish issue.

This is where they left off: our next session we'll see how well Travis does on his astrogation, how well the doctor and scientist manage to continue their research on Girly Girl (the name of the Lord Fish, who is in a huge tank in the main lab).

Selshor is where the Katydid crashed more than 6 months ago, getting on to a year now.  Selshor is outside the Imperium, so while the physical status are well known, the politics and society are not as well known.  Dr. Francine Occa, who was a crew member of the Katydid and managed to escape, only knows that the population is even more xenophobic than Cyan's ruling class, and that the ship crashed on a high plateau with extremely thin air. Her rescue was quite fortunate - Selshor does not get many passing ships.  She recommends extreme caution in their approach.

Traveller Sunday

Well, it was a shorted than normal session. Both players were tired, and the open sandbox universe can be a bit slow at times when playing law abiding citizens. So all we ended up doing was some site seeing in Pargu Arcology, and set up the charter for the next day.  Travis went bar-hopping a bit so he could watch the fireworks. The Black Rose Bar had a yuppie crowd, and young Mr. Roanoke fit in fairly well, He was even invited to a private game in the corner after a bit. He lost a few credits, got mildly buzzed from some light beer, and eventually returned back to the Hotel 76 rooms he and the good doctor were sharing.

Next session we'll get out on the open seas in our attempt to capture a Lord Fish.  And another call from Ferdinado indicates that the Aslan ship that landed a couple of days ago is still at the class D port, but most of the crew has left the ship. There is little traffic at Kyslion Downport, so the two SPA officers do tend to get chatty, and Li does like to get a lay of the land.  She has sent a message to our Travellers to be aware of strange Aslan.

As a side note, some of the acreage devoted to mudda herds are controlled by Aslan - with their almost primordial need for land, the arcologies are not a place for them.  There is a small clan that manages a couple of large mudda herds nearby.  So the arcology does see a few non-humans, predominately Aslan, but also including Vargr, Bwaps, and several other alien species. There is even a doctors office with a Virushi, as they really enjoy the dense atmosphere.

Day 2 is seeing cloudy skies and choppy seas.  Hopefully no one will get seasick!

Traveller Sunday

Due to miscommunication (I blame the X-Boats) we did not get to play last Sunday. And this Sunday Bryson & I are out of town, so it looks like it will be June 25th before we get to play again.

In our game universe, the gaming respite can be reflected by the celebration of Day 001 - Holiday. So it is now 001-1105, and we're firmly into the Golden Age of Traveller so to speak.  There will be celebrations even though it is very unlikely that Kryslion has a 365 day year (I need to dig back into the world stats).

So enjoy the holiday!

Traveller Sunday

One of my players was out of town, so no Traveller gaming this weekend.  I did get in 3 games of Munchkins with my son & his girl friend, so at least there was some gaming involved.

I also created the rough deck plans for the air cushion vehicle to be used for the charter fishing trip (a 3 hour cruise...).  I've generated the encounter tables from Heaven & Earth (gotta love old software that just works), and hunters (fishermen and women) using Supplement 4, and have the seaside town all ready to go.

Maybe I'll try & update the basic image from Google Draw using GIMP or something to make it a bit better.  I just never have enough time it seems (or time that intersects with desire).

Traveller Sunday - Kryslion Cultural Profile

Dug out my old Grand Census book, and generated the cultural profile for Kryslion.  I will have to see about making IS Form 22 later...also adding some T5 stuff from TravellerMap (great resource!)

But here is what I rolled up:

High Common TL:  9
Low Common TL: 8

Energy: 9
Computers: 9
Communications: 8u
Medical: 8
Environmental: B  (with a breathable but dense atmo, this was an interesting roll)

Land Transport: 9 - early grav, ultra-high speed trains

Water: 8 - triphibian vehicles, early gills  (hovercraft are quite common per my interpretation with the dense atmosphere)

Air: B - personal g-tubes, heavy grav modules

Space: 9 - Jump 1, sublight interstellar

Personal Military: 9 - laser weapons

Heavy Military:  9 - lightweight composite laminates

Importance: 0 - unimportant

Homogenity: B - discordant

Acceptance:  A - very friendly

Strangeness: 6

Symbols:  A

Next are two values per item - first is how they profess to be, 2nd is how they really are.

Progressiveness: Conservative / Indifferent  [A/A]

Aggressiveness: Unaggressive / Peaceable [9/B]

Extensiveness: Discordant / Friendly [B/5 - used T5 value]

Uniformity of Law: Territorial  9-999A9

   9 - overall (UWP)

   9 - Weapons

   9 - Trade

   9 - Criminal Law

   A - Civil Law (guess with this population it gets interesting)

   9 - Personal Freedom

Cultural Notes

As previously noted, tattoos are a way of showing social status, including what region you are from. Each arcology has its own symbol and some residents enjoy showing arcology pride. This applies to most of the population.

Additionally, children often care for their elders.

Religious Profile
Just a single predominant religion:  68A5C6-7
   God View       6 - Influential monotheism: God interacts with sophonts only at key moments in life.
   Spiritual Aim  8 - ethical and moral standards are their own reward
   Devotion Req  A - quarterly, every 3 months
   Organization   5 - loose hierarchy
   Liturgical Formality C - informal study groups
   Missionary Fervor 6 - ordinary and willing to convert any sophont
   Number of adherents 7 - 10,000,000 0 - 99,999,999: say 90 million or so.

I'll try and update the guide at some point.

Traveller Sunday - NPC Crew Interactions

The NPCs have been relatively quiet and part of the background without any real personalities.

I've generated a NPC interaction graph, and we'll base the interrelationships off those rolls using the reaction table. Having a 2 in there really indicates some serious hatred for some reason....someone wit ha 12 and the other NOC with a much lower score for may indicate unrequited love...

And it looks like I forgot Li...will have to add her.  So you read the table down the left hand side for that person and how they react to the others. So Franklin really dislikes Purity but gets along well enough with everyone else. Purity does not seem to like Franklin any better.

I need to add more NPC interactions I think to our play.

	Franklin	Ferdinando	Purity	Francine	Quentin
Franklin	-	6	3	11	9
Ferdinando	5	-	9	8	5
Purity	4	11	-	8	2
Francine	5	10	4	-	11
Quentin	10	12	6	8	-

Traveller Sunday - On To Kryslion

Away from one dictator and to another!  At least this one is charismatic.  I've started working on the Kryslion guide ( Kyrslion ), and they turn out to be a gregarious people who love crowds and tattoos. Hey - it was what was rolled up, and with a population of 50 billion, liking crowds is a good thing!

Traveller Tracker

Not too much to post here.  I did start on the ship view, which will allow you to edit the ship.  I've got the basic data binding in place, but want to make the view a bit prettier.  Bit at least I got the initial databinding in place!  Next to see if I can go back & update the data as well as reading it.

But it seems there is a VS update all the time, so once I got that at least something done, I went with the update.  So maybe some more this week depending on how much time I get. Real life is not always nice, so my time with this is more limited than I would like, especially once I get started.

Traveller Sunday - Leaving Cyan

After a day of recovery (that fast drug works miracles apparently, although Travis is still sore and Pennity will be in the hospital for a few months) our Travellers take the Renegade Scout Ship to the Way Station.  I had the poster of the ship laid out & we got to look that over a bit, but as it was just a 2 day trip or so to the Way Station, it was simply there to look at.

The first stop in the belt was at Ming Station, the main administrative hub. They met the Way Station Scout Commander, transferred the funding form the Countess for the new fuel purifier, and opened some initial talks about possibly sharing research from the Lord Fish deal.

They then took a shuttle with the scientists from Le Suroit to a Vanguard class station (another poster map, again just there for looks) where they caught up with the engineers who were finalizing the ship updates.  The Lab Ship now has a spoke that goes all the way through, which contains both the fuel purification system as well as enough fuel so that they can still do a Jump-1. Their manuever spped has dropped a little, so intead of 1G they have something like .95G - close enough not to worry about.  Ferdinando has the drives all recalibrated for the new mass and volume.  While Travis went on a simulator to verify he could still pilot the updated ship (and had 2 very unsuccessful rolls with finally getting a succes - we pictured the scene in Galaxy Quest when the pilot takes the ship out, scraping the port), Li made the rounds and I made reaction rolls for each of the crew. Even without a persuade DM, the lowest was a 7, the highest a 10. So the new crew member apparently fits in quite well.

Sadly, I really had nothing at the Way Station that needed doing despite having my nice big map of Flash Gordon references. So after another day of getting things packed up, the crew move out 100D from the belt, and make the jump to Kryslion.  Travis rolled a 7, so the just while successful will be a bit further out than 100D.

And so I need to start the Kryslion world work up.

Traveller Sunday - The Rescue of Purity

Over breakfast on the day Purity was to return so that they could go to the Scout Way Station, our Travellers got a frantic call from Purity as she was approaching the starport in the grav APC.  She got cut off in the middle of warning about an incoming object.  Travis, Boris & Li rush to the starport administration building, and call the prison Warden.  He has just found out that the APC was shot down on the east end of Startown, and has no further word.  He urges our adventurers to contact the Marine and port Authority.  The Marines convene a quick meeting.  Due to the political situation, they cannot mount a heavily armed response to this situation.  They do not want a repeat of the riots from 5 years ago, which is what brought the Marines in the first place.

However, lending them Pennity and Pagille, along with a modified ACV (air cushion vehicle or hovercraft) cargo van, our heroes sally forth from the port.  Both characters managed to fail negotiating with the customs official for exiting the port; however, a fortuitous roll by Pennity let them pass through the gates without much more of a delay.  They had their guns in hidden ports - handy having access to high technology which can bypass the local authority's scanning devices as the Marines have discovered for several covert excursions.

I had 3 encounters listed in my maps. The got through customs easily enough.  The warehouse district I managed to roll citizens, and only 2 of them.  So while the reaction roll was pretty low, 2 locals against 4 in a hover van are not good odds so they just gave our group dirty looks.  Finally closing in on the light industrial area, I had everyone roll for surprise.  No one surprised anyone.

As our group approached the rising plume of smoke that they could now see, and noticing people walking in what was obvious to our Marines as a search pattern, they were stopped by 2 well armed soldiers. A brief conversation lead nowhere when there were suddenly shots heard against the roof of the van.  Fortunately, the van had been updated to carry armor. However, the two soldiers in front pulled back and started shooting as well.

At this point Pennity, at the urging of one of the players (sad I can't recall who now...) managed to speed up and take out one of the gunmen, while Pagille rolled down hos window and started shooting as well, managing to take out the other gunmen.  It was at this point more shots were being fired, and Pennity, seeking cover closer to the downed APC, smashed through the loading dock of a small warehouse, crashing to a halt next to several barrels of beer. 

Pagille had been shot during this maneuver, and Dr. Duk-Lyle was using first aid to stabilize him.  At first, due to the positions of Pagille in the front, it was not a particularly successful staunching of the wounds. While Boris moved the injured Marine to the read seats, Travis leapt out the front and grabbed Pagille's gauss rifle. Pennity had left her side with a trusty laser rifle, and was going out the other side of the vehicle.

Pagille was stabilized, and Travis shot very badly several times. While not hitting anyone, he came close to hitting his boots.  Pennity manged to take out at least one gunman but then was almost fatally wounded by a very successful shot.  Boris was quick to the rescue and managed to ably stabilize her. At this point they got unexpected help from above - apparently the APC driver and Purity were in this building, and the driver was lending support from the second floor.  Purity came over to the doctor and Pennity, and getting the Marine's gun started shooting as well.

Travis got hit hard, and falls unconscious to the ground. Purity is not particularly successfully shooting either, but the gunmen are falling back, and the Marines do have more support coming in.

With a lucky shot, the pilot takes down the leader of the group, and the rest flee as the Marines finally show up. 

All are rushed back to the port and get hospitalized and taken care of. Pennity will be recuperating for some time (she was down to 1 point left). Travis opted for the medical slow drug and is hooked up to intravenous feeding for the next 24 hours.

The doctor gets a commendation for his aid, Travis gets free medical care.

Also discovered that these soldiers are actually from the Blade mercenary group from Kryslion. Aphix hired them as plausible deniability several months back, for both training and covert acts against the rebels. Fearing that Purity had discovered something at the prison (she did not) she wanted her killed before she could report anything. 

Fortunately the APC has great airbags as both Purity and the pilot survived without injury.  THe Baldes commander is getting sent to Imperial Prison.  All this fits in with the latest issue of the Freelance Traveller where the mercenary group is described.  As this takes place in 1104, and in the article the leader of the 2nd Platoon is in Imperial Prison, this worked out well to bring in some flavor from some one else's OTU.

Sunday Traveller

The morning started with another light snowfall, covering the port's ;anding fields and buildings. The snow softened the harsh outlines of the older buildings, and covered the ravages of the riots that, five years on, still lingered.

Boris, Travis and Li are having breakfast at the hotels small canteen when their comm's buzz with an incoming call. Li does not yet have a ship comm, she will have to wait until you get to the ship at the Way Station.  It's Purity - she was nearing the port in a prison grav APC when a small rocket launched grenade hit the vehicle, causing it to crash in the eastern part of Startown.  Apparently grav APCs are fairly resilient as she and pilot both survived the crash, but the vehicle itself is pretty much totaled. They have moved to a nearby industrial building and are trying to hide as it appears a small, armed crowd has arrived. She is unable to determine if the crowd are the ones who fired the grenade or have just shown up.  Her final words are, "I don't exactly blend in here well, but we'll continue on foot to approach the port and..." as the transmission gets cut.

Below is the map - the orange circle is where they went down. Talking with the port warden and military officials, due to the current state of affairs on Cyan, the do not recommend a full scale Imperial military approach - they do not want another riot.  They are recommending a more nuanced approach. They have several local ground vehicles that have been modified somewhat to offer better protection, and advise dressing more like the locals.  They will also supply the two Marines that accompanied Boris & Travis on their prison research.  Arms will be concealed in the vehicle and should be able to pass through customs.  So you can bring your pistol and cudgel if you so desire (there is always a chance, however, that you may get caught in customs; however, the Marines assure you that they've done this on more than one occasion for a variety of reasons).

From what the port can tell, there is interference in that area of Startown - the comms are being jammed.  Additionally, no one has claimed credit for the attack.  The port's opinion is that it is not the rebel faction - while not directly pro-Imperial, they do want further trade and access to Imperial goods and services. However, like any movement there are a variety if factions.  They are also not ruling out the local Army, particularly as rocket launched grenades are not easy to come by.

The point of impact is about 10 kilometers out, in a light industrial area.

Traveller Tracker Overview

I've got the basic framework set up as below (most to be actually filled in).  The main screen has a frame where all the content goes based on the the menu options on the left and the active ship.  The plan is you pick or add a ship, and can track your cargo, fuel and all that.  Repeating what I already did 7 years ago but for UWP and to actually publish on the Windows App store.  Hopefully I'll have the ship and class editors in place soon and can actually start seeing if this works.

Traveller Tracker

Having learned that foreign keys are not good, I can still set the data models up the way I want to, then I comment out the code in the migration script that deals with foreign keys. It does mean that I nave to manually link things together, but that's not particularly difficult.

I've added a new page to edit the ship details - not much is there yet, but I can navigate to it.  I am going to rewrite the main page to reflect my initial design - I've added a frame which is where we navigate to.  So the left hand will be navigation style buttons, the main part will be the actual data.

I think the options will be (going vertically down the left):

• List - list the ships in your database. There will be a button or link to get to the details
• Ship - details of the ship. Allow editing, and loads this ship as your current ship.
• Classes - allows you to edit the ship classes
• Log - current log of the active ship

That's a guess for the moment.  The class is what defines the ship tonnage, jump, maneuver and power systems, cargo and maybe fuel.

But progress is slowly being made.

Traveller Sunday

Flying back to the Cyan Port, there is a light snow covering the tarmacs, and the occasional craft launching or landing in the distance.  Boris, Travis and Li part ways with their Marine guards, and go to the Port Hotel where they have a few hours before their dinner with the Countess. Li leaves to get some shopping done, while Travis and the Doctor clean up and do some research on the Countess and try to catch up on local news.  Most of the local news is state-sponsored propaganda, but even there is little negative news on the Countess. The Imperial database indicates she has been a career diplomat and has moved up through the ranks consistently over the years, and is now the Imperial representative on Cyan. Her goals, as listed by her bio, are to bring peace and prosperity to Cyan. Knowing how the nobility works, our Travellers are aware that prosperity will also be coming to the Countess.

Li returns with several bags, and asks if she too is invited. As she was, both Boris and Dr Duk-Lyle almost appear affronted that she even made such a suggestion.  So quickly pulls out a fairly spectacular semi-formal gown, and returns.  Amidst the praise, a slight bump on her thigh is revealed to be a small holster and pistol. With a grin and "it doesn't hurt a girl to try" she quite easily leaves the small body pistol behind. 

They are met at the hotel entrance by a port taxi, and are quickly shuttled to the racing yacht. Met at the airlock by an austere butler, they are ushered into the dining area where they are met with delight by Countess Millie. A coffee and introductions are exchanged, and Millie offers a tour of the yacht before dinner. Travis recognizes the coffee from Trane, and finds to his dismay that the Countess imports it at a fair expense. The yacht is a Kitaro class racing yacht, so is not a typical Traveller yacht.  Fine yet subdued appointments show a refined taste. They are led to the large kitchen where Chef Waldo and is sous-chef are busy cooking. They are almost ejected from the kitchen by the same chef who is busy cooking some sort of fish.  The rest of the tour goes well, from the small pool with the complete holographic wall system, to the larger than expected engineering section. At the rear of the ship is the garage, currently with 2 grav speeders.

At pleasant chime announces that dinner is served. Returning to the dining room, they encounter the Marquis Juliette Sung Ottowald who they last saw on Trane.  A very pleasant dinner was served, and making rolls against social, Travis noted that the fish is exceptional and wonders if it is Lord Fish.  And indeed it is (note that Lord Fish is from the http://travellerrepublik.blogspot.com/ site - thanks!)  The Countess notes that she has an idea she would like to discuss after dinner.

So, after a resplendent meal, after dinner is served causing Travis to grimace at missed opportunity. Her plan is to finance Le Suroit to research keeping the Lord Fish tasty for more than a couple of days after processing. This fish is not only expensive due to its rarity but also that it has to be shipped live - once dead, despite any preparation, the taste and value rapidly declines.  She offers a cool Cr250,000, enough to pay for the fuel processor as well as purchase a fish or two at Kryslion, their next port of call. Li continues to elbow both Travis and Dr. Duk-Lyle, so they take an electronic copy of the contract to review it.

They end up hiring an advocate to review the document, and decide to modify it so that they will also get a cut of the profits going forward should they actually manage to find a way to preserve the flesh. The Countess readily agrees to the new contract. So now they have a six month window at Kryslion to see if they can do what has not been done despite more than 50 years of trying.

Now from the GM/Player perspective: this allows the players to finance the Cr180,000 fuel system they needed for the ship, as well as give them some additional incentive to explore Kryslion.   They do not have a definitive time to get to Selshor (the original goal of this adventure, to retrieve the Katydid. However, the Scouts would prefer a sooner rather than later).  The chances of them succeeding are pretty low but not impossible. It will be a weekly roll that has to be met each time. Success will move forward, near success may lead them to an incorrect research path, and failure may really mess them up. This is a task chain, so I need to read up on that.

Additionally, I had set up some maps to have Purity shot down in Startown. This was an option if they wanted to get some combat in. Combat being possibly fatal in Traveller. Also gives me a chance to bring out a Zombie game that has road and building tiles so we can have a tactical game. Zombies will be the opponents.  Just using the pieces...

Traveller Tracker - Foreign Keys

After the initial jubilation of being able to use SQLite with Entity Framework in a UWP application, I was dismayed to discover that foreign keys are not supported in SQLite.  EF has some nice tooling for database migrations, but sadly they will not work.

There are workarounds, which is what I am probably going to end up doing. I just have to be careful about the naming conventions so I don't accidently create a FK in the models.

But I have learned how to add additional tables into the migration path, and now knowing about some of the limitations, I can work around them. 

I must be getting excited by all this again - had the strangest dreams about the code base last night. Or perhaps that was the carrot cake...

Animal Encounters

There are a lot of interesting animals here on planet Earth.  One I like is the giraffe - just how unlikely is it for something like this to be?

A famous giraffe, April, has given birth to a baby boy.  But just watching her gives me some ideas for animal encounters (I may have to revive the PETA of Romar for the next chapter or two).

Traveller Tracker

Finally got some time to get back to this. And finally have it at least loading and running with an attached SQLite database.

Biggest issue was a naming convention: using Entity Framework and the SQLite stuff there are some assumptions about naming conventions. Fortunately MS/SQLite borrowed from the Ruby On Rails, and I've no idea where they got their ideas from.

Regardless, the screen comes up, and you can add a ship to the library.  Right now it has a hard-coded name while I was verifying things worked; next step is to allow editing and have a full ship detail page (the main page is just a list of your ships. An ugly list at the moment...)

I also updated VS2017 to the latest version and few other things, but now progress in theory should be a tad faster as I think I've got basic I/O in place.

And I learned a bit more about DB migrations. This is a code-first program, meaning the DB is basically defined in the code, and we use migrations to update the database. So the 1st migration just sets up the ship table, and you can see how ShipID is the primary key.

using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using TravellerTracker.Models;
namespace TravellerTracker.Migrations
{
    [DbContext(typeof(TravellerContext))]
    [Migration("20170416155153_initialShip")]
    partial class initialShip
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
            modelBuilder
                .HasAnnotation("ProductVersion", "1.1.1");
            modelBuilder.Entity("Traveller.Models.Ship", b =>
                {
                    b.Property("ShipId")
                        .ValueGeneratedOnAdd();
                    b.Property("CargoCapacity");
                    b.Property("CargoCarried");
                    b.Property("FuelPerJump");
                    b.Property("Name");
                    b.Property("dTons");
                    b.HasKey("ShipId");
                    b.ToTable("Ships");
                });
        }
    }
}

Cyan Starport Impressions

Starport Impressions

Despite being around for several centuries, the Cyan star port has never received an official name.  Cyan government has not been actively pursuing interstellar trade.

The primary administrative complex is a rambling structure, added to almost randomly over the years. The original control tower was abandoned more than a century before and is used for storage and the rare sight seeing citizen.  The new tower, more than 80 years old, presides several stories above the old tower and give a good vantage over the entire port.

The massive customs building houses what appears to be hundreds of offices and officials. Security is very evident throughout this building, which is the primary way of leaving the port. Security checks are very thorough for a TL A egress. Returning to the port can also be a hassle depending on crowds, the mood of the local army at the time, as well as the latest edict from the dictator. There are dozens of warehouses nearby both inside and outside the fence, some of which are still not usable.

Accommodations are adequate, but not up to high passage standards. And in the current siege mentality, things are crowded. Most merchants do not leave the port, relying on local brokers for cargoes. The Marine squads are housed in one of the hotels, leaving even fewer spaces for visitors. Marines patrol the perimeter constantly, primarily to maintain a visible watch over the occasional crowds outside.

There is the constant sound of grav vehicles loading and unloading cargo. Despite being a class C port, it is on the leg to the subsector capitol so has a larger than expected number of ships. Additionally, the local SDB fleet is housed here, and make trips daily. There are two airport style runways, so that local aircraft can transport cargo or people.  All has to be inspected by customs prior to leaving the port.

Startown was damaged in the riots of 5 years ago, and several buildings remain burnt out husks of buildings. Military patrols are constantly roving through the city, with more near the port boundaries.  It is not as rambunctious as many startowns are, but still has quite the variety of people.  There are still several brokers and trading guilds available in startown.