---
# System prepended metadata

title: Schema of the database of model zoo

---

# Schema of DB of model zoo
This is a simple design of the model zoo's database schema.

### **Table: EarthDataset**

| Column Name | Data Type | Description |
| --- | --- | --- |
| datasetID | Integer (Primary Key) | Unique identifier for each dataset |
| name | String | Name of the dataset |
| type | String (Enum: Image, RNA-seq, etc.) | Type of the dataset |
| source | String | Source or origin of the dataset |
| description | Text | Brief about the dataset |
| link | String (URL) | Link to download or access dataset |

---

### **Table: SpaceDataset**

| Column Name | Data Type | Description |
| --- | --- | --- |
| spaceDatasetID | Integer (Primary Key) | Unique identifier for each space dataset |
| name | String | Name of the space dataset |
| type | String (Enum: Image, RNA-seq, etc.) | Type of the space dataset |
| mission | String | Associated space mission |
| description | Text | Brief about the space dataset |
| link | String (URL) | Link to download or access space dataset |

---

### **Table: Model**

| Column Name | Data Type | Description |
| --- | --- | --- |
| modelID | Integer (Primary Key) | Unique identifier for each model |
| name | String | Name of the model |
| architecture | String (Enum: ResNet, DeepBind, etc.) | Model architecture |
| description | Text | Brief about the model |
| preTrainedOn | Integer (Foreign Key: EarthDataset.datasetID) | Dataset on which the model was pre-trained |
| link | String (URL) | Link to download or access model weights |

---

### **Table: SpaceTransferModel**

| Column Name | Data Type | Description |
| --- | --- | --- |
| transferModelID | Integer (Primary Key) | Unique identifier for each space transfer model |
| baseModelID | Integer (Foreign Key: Model.modelID) | The base model used |
| trainedOn | Integer (Foreign Key: SpaceDataset.spaceDatasetID) | Space dataset used for transfer learning |
| description | Text | Brief about how the model was adapted for space data |
| link | String (URL) | Link to download or access fine-tuned model weights |

### **Table: Model_EarthDataset_Relationship**

| Column Name | Data Type | Description |
| --- | --- | --- |
| modelID | Integer (Foreign Key: Model.modelID) | ID of the model |
| datasetID | Integer (Foreign Key: EarthDataset.datasetID) | ID of the Earth dataset |

---

### **Table: SpaceTransferModel_SpaceDataset_Relationship**

| Column Name | Data Type | Description |
| --- | --- | --- |
| transferModelID | Integer (Foreign Key: SpaceTransferModel.transferModelID) | ID of the transfer model |
| spaceDatasetID | Integer (Foreign Key: SpaceDataset.spaceDatasetID) | ID of the space dataset |