# Chronicle Coordicide Data Layout

## Tables

### Messages

- message_id: text
- message: blob
- marker: blob
- is_conflicted: bool
- sequence_id: blob
- past_markers: list[blob]
- future_markers: list[blob]

### Parents

- message_id: text
- partition_id: smallint
- parent_id: text
- issued: timestamp

### Indexes

- indexation: blob
- partition_id: smallint
- issued: timestamp
- message_id: text
- trending_idx: integer

### Transactions

- output_id
- transaction_id: blob
- idx: smallint
- variant: text
- message_id: text
- inclusion_state: blob
- issued: timestamp

### Addresses

- address: text
- partition_id: smallint
- output_type: tinyint
- output_id
- transaction_id: blob
- idx: smallint
- amount: bigint
- address_type: tinyint
- inclusion_state: blob
- issued: timestamp
- message_id: text
- trending_idx?: integer

### Contracts

- ???

### Hints

- hint: text
- variant: text
- partition_id: smallint
- issued: timestamp

### Sync

- ???

### Analytics

- ???

## Migration

## Access

### Select Queries

### Insert Queries

## API Endpoints