summaryrefslogtreecommitdiff
path: root/app/trading/migrations/0001_initial.py
blob: 54f803200fcb99070478b65726611b07444a9f8d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
# Generated by Django 3.2.4 on 2021-07-13 14:27

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='LuxTradeModel',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('symbol', models.CharField(max_length=256)),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('entry_price', models.FloatField()),
                ('stop_price', models.FloatField()),
                ('target_price', models.FloatField()),
                ('shares', models.FloatField()),
                ('percent_portfolio', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='Ticker',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('symbol', models.CharField(max_length=9)),
                ('name', models.CharField(blank=True, max_length=243, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='TradeJrnl',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('body_markdown', models.TextField(blank=True)),
                ('body_html', models.TextField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='OptionsTrade',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateTimeField()),
                ('transaction_code', models.CharField(choices=[('Trade', 'Trade')], max_length=25)),
                ('transaction_subcode', models.CharField(choices=[('Buy to Open', 'Buy to Open'), ('Sell to Open', 'Sell to Open'), ('Sell to Close', 'Sell to Close')], max_length=25)),
                ('buy_sell', models.CharField(choices=[('Buy', 'Buy'), ('Sell', 'Sell')], max_length=4)),
                ('open_close', models.CharField(choices=[('Open', 'Open'), ('Close', 'Close')], max_length=5)),
                ('quantity', models.FloatField()),
                ('expiration_date', models.DateTimeField()),
                ('strike', models.FloatField()),
                ('call_put', models.CharField(choices=[('C', 'Call'), ('P', 'Put')], max_length=4)),
                ('price', models.FloatField()),
                ('fees', models.FloatField()),
                ('amount', models.FloatField()),
                ('description', models.TextField(blank=True)),
                ('symbol', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='trading.ticker')),
            ],
        ),
    ]