class dataset(models.Model):
_id = models.ObjectIdField()
post_title = models.CharField(max_length=255)
data_title = models.CharField(max_length=255)
tags = models.JSONField()
user_details = models.JSONField()
objects = models.DjongoManager()
class Resource(models.Model):
_id = models.ObjectIdField()
product_id = models.CharField(max_length=100, blank=True, null=True)
version = models.CharField(max_length=20) # This field maps the Product Spec version
provider = models.ForeignKey(Organization, on_delete=models.DO_NOTHING)
content_type = models.CharField(max_length=100)
download_link = models.URLField()
resource_path = models.CharField(max_length=100)
old_versions = models.ArrayField(
model_container=ResourceVersion
)
state = models.CharField(max_length=20)
resource_type = models.CharField(max_length=100, blank=True, null=True)
is_public = models.BooleanField(default=False)
has_terms = models.BooleanField(default=False)
bundled_assets = models.JSONField(default=[]) # List
meta_info = models.JSONField(default={}) # Dict
def get_url(self):
return self.download_link
def get_uri(self):
base_uri = settings.SITE
return urljoin(base_uri, 'charging/api/assetManagement/assets/' + str(self.pk))
class Meta:
app_label = 'wstore'
class Posts(models.Model):
id = models.ObjectIdField()
post_title = models.CharField(max_length=255)
post_description = models.TextField()
comment= models.JSONField()
tags = models.JSONField()
user_details = models.JSONField()
class recruit_basic_question(models.Model):
number = models.PositiveIntegerField()
basic = models.JSONField()
optional = models.JSONField()
club_id = models.IntegerField()
user_id = models.PositiveIntegerField()
rbq_id = models.CharField(unique=True, primary_key=True, max_length=15)
objects = models.DjongoManager()
class interview_group(models.Model):
# 이미 조가 짜여져서 front 하단에 보이는 url 데이터 카톡에서 확인
rf_id = models.CharField(max_length=15, default=None)
interviewer = models.JSONField()
manager = models.JSONField()
etc = models.JSONField()
fixed = models.BooleanField(default=False) #임시인지 확정된 값인지 저장
objects = models.DjongoManager()
class Posts(models.Model):
id = models.AutoField(primary_key=True)
post_title = models.CharField(max_length=255)
post_description = models.TextField()
comment = models.JSONField()
tags = models.JSONField()
user_details = models.JSONField()
objects = models.DjongoManager()
class Sample(models.Model):
_id = models.ObjectIdField(primary_key=True)
header = models.JSONField(null=False, editable=False)
time_start = models.DateTimeField(editable=False)
time_end = models.DateTimeField(editable=False)
captured_data = models.JSONField(editable=False, null=False, blank=False)
collect = models.ForeignKey(to=Collect,
to_field='_id',
on_delete=models.CASCADE)
class recruit_format(models.Model):
type_choices = (("1", "면접전형"), ("2", "서류전형"), ("3", "면접+서류전형"))
Type = models.CharField(max_length=15, choices=type_choices, default="1")
club_id = models.IntegerField(default=0)
user_id = models.PositiveIntegerField(default=0)
rf_id = models.CharField(unique=True, primary_key=True, max_length=15)
approval_info = models.JSONField(default=[])
time = models.JSONField(default=[])
run_time = models.IntegerField(default=0)
rest_time = models.IntegerField(default=0)
Multiple_choice = models.JSONField(default=[])
Short_answer = models.JSONField(default=[])
long_answer = models.JSONField(default=[])
objects = models.DjongoManager()
class Contract(models.Model):
item_id = models.CharField(
max_length=50, primary_key=True
) # Workarround to prevent issues, not really a primary Key
product_id = models.CharField(max_length=50, blank=True, null=True)
offering = models.CharField(
max_length=50
) # Offering.pk as Foreing Key is not working for EmbeddedFields
#offering = models.ForeignKey(Offering, on_delete=models.DO_NOTHING)
# Parsed version of the pricing model used to calculate charges
pricing_model = models.JSONField(default={}) # Dict
# Date of the last charge to the customer
last_charge = models.DateTimeField(blank=True, null=True)
# List with the made charges
charges = models.ArrayField(model_container=Charge, default=[])
# Usage fields
correlation_number = models.IntegerField(default=0)
last_usage = models.DateTimeField(blank=True, null=True)
# Revenue sharing product class
revenue_class = models.CharField(max_length=15, blank=True, null=True)
suspended = models.BooleanField(default=False)
terminated = models.BooleanField(default=False)
class Meta:
managed = False
def __getitem__(self, name):
return getattr(self, name)
class interview_manager(models.Model):
# 운영진 들의 면접가능시간 저장하는 모델
run_time = models.PositiveIntegerField(default=0)
rest_time = models.PositiveIntegerField(default=0)
rf_id = models.CharField(max_length=15, default=None)
manager = models.JSONField()
objects = models.DjongoManager()
class Expense(models.Model): category = models.CharField(max_length=50) amunt = models.DecimalField(max_digits=5, decimal_places=2,blank=True,null=True) price = models.PositiveIntegerField(blank=True , null=True) array = models.ArrayField(model_container=ArrayFieldModel) embedded = models.EmbeddedField(model_container=EmbeddedFieldModel) imgs = models.JSONField(default=[])
class Equipment(models.Model):
_id = models.CharField(max_length=12, primary_key=True)
name = models.CharField(max_length=255)
description = models.TextField(null=False, blank=False)
samp_frequency = models.IntegerField(null=False)
sensors = models.JSONField(null=False)
available = models.BooleanField(default=True)
class GamePlay(models.Model):
room_id = models.IntegerField(primary_key=True)
players = models.JSONField()
objects = models.DjongoManager()
def __str__(self):
return str(self.players)
class User(models.Model):
group_choice = (('g1', '학생'), ('g2', '직장인'), ('g3', '일반인'))
group = models.CharField(max_length=3, choices=group_choice, default="g1")
name = models.CharField(max_length=15)
education = models.JSONField()
grader_choice = (("gr1", "1학년"), ("gr2", "2학년"), ("gr3", "3학년"), ("gr4",
"4학년"))
grader = models.CharField(max_length=4,
choices=grader_choice,
default="gr1")
states_chocie = (("s1", "재학"), ("s2", "휴학"), ("s3", "졸업"))
states = models.CharField(max_length=3,
choices=states_chocie,
default="s1")
birthday = models.CharField(max_length=12)
telephone = models.CharField(max_length=15)
email = models.EmailField()
address = models.TextField()
self_image = models.CharField(max_length=10)
date = models.DateField(auto_now_add=True)
user_id = models.PositiveIntegerField(unique=True, primary_key=True)
objects = models.DjongoManager()
def __str__(self):
return str(self.user_id)
class QuestionRightAnswer(models.Model):
question_num = models.IntegerField()
question_id = models.CharField()
right_options = models.JSONField()
class Meta:
abstract = True
class TranslationMap(models.Model):
class Meta:
abstract = True
source_place = models.PositiveIntegerField(null=True)
coordinate = models.JSONField(max_length=2)
translation = models.TextField()
class Patient(models.Model):
_id = models.CharField(null=False,
unique=True,
primary_key=True,
max_length=11)
birth_date = models.DateField(null=True)
first_name = models.CharField(null=False, max_length=255)
last_name = models.CharField(null=False, max_length=255)
email = models.EmailField(blank=True,
null=True,
validators=[
EmailValidator,
])
phone = models.CharField(max_length=255, null=True)
address = models.CharField(max_length=255, null=True)
lat = models.CharField(max_length=255, null=True)
long = models.CharField(max_length=255, null=True)
collects = models.JSONField(null=True,
blank=True,
editable=False,
default=[])
registration_date = models.DateTimeField(default=timezone.now)
registered_by = models.EmailField(blank=True,
null=True,
validators=[
EmailValidator,
])
class google_api(models.Model):
date = models.DateTimeField(default=datetime.datetime.now(IST))
data = models.JSONField(null=False)
class Meta:
verbose_name = 'Google_api_log'
verbose_name_plural = 'Google_api_logs'
ordering = ['date']
class Stop(models.Model):
stop_id = models.CharField(max_length=70, blank=False, primary_key=True)
stop_name = models.CharField(max_length=200, blank=False, default='')
station_id = models.CharField(max_length=70, blank=False, default='')
maxDelta = models.IntegerField(default=0)
avgDelta = models.IntegerField(default=0)
trips = models.ArrayField(model_container=StopTrip, default=None)
current_delays = models.JSONField(name='current_delays')
class Organization(models.Model):
_id = models.ObjectIdField()
name = models.CharField(max_length=50, unique=True)
notification_url = models.CharField(max_length=300, null=True, blank=True)
acquired_offerings = models.JSONField(default=[]) # List
private = models.BooleanField(default=True)
correlation_number = models.IntegerField(default=0)
managers = models.JSONField(default=[]) # List
actor_id = models.CharField(null=True, blank=True, max_length=100)
idp = models.CharField(null=True, blank=True, max_length=100)
def get_party_url(self):
party_type = 'individual' if self.private else 'organization'
parsed_site = urlparse(settings.SITE)
return '{}://{}/partyManagement/{}/{}'.format(parsed_site.scheme,
parsed_site.netloc,
party_type, self.name)
class Schema(models.Model):
author = models.ForeignKey(User, on_delete=models.CASCADE, default=None)
name = models.CharField(max_length=64)
separator = models.CharField(max_length=10)
date = models.DateTimeField(default=datetime.now(), editable=False)
columns = models.JSONField()
def __str__(self):
return "%s by %s" % (self.name, self.author)
class Collect(models.Model):
_id = models.ObjectIdField(primary_key=True)
timestamp_init = models.DateTimeField(editable=False)
timestamp_fin = models.DateTimeField(editable=False)
samples = models.JSONField(null=True, blank=True, default=[])
equipment = models.ForeignKey(to=Equipment,
to_field='_id',
on_delete=models.CASCADE)
patient_id = models.CharField(max_length=11, editable=False, null=False)
class Organization(models.Model):
org_id = models.AutoField(primary_key=True)
org_name = models.CharField(max_length=256, unique=True)
address = models.JSONField(null=False, blank=False)
status = models.BooleanField(default=False)
inventory_items_refresh_job = models.IntegerField(default=1)
repeat_interval = models.CharField(max_length=256, default='days')
ftp_location = models.CharField(max_length=256, null=True)
calendar_date = models.CharField(max_length=100)
file = models.FileField(null=True)
class Post(models.Model):
_id = models.ObjectIdField()
title = models.CharField(max_length=100)
body = models.TextField()
tags = models.JSONField(null=True)
published_date = models.DateTimeField(auto_now_add=True) #알아서 날짜랑 시간 적어줌
objects = models.DjongoManager()
def __str__(self):
return "{} / {}".format(self.title, self._id)
class user_circle(models.Model):
# club이랑 onetomany 해야함
# embedded 나중에......
user_id = models.PositiveIntegerField()
states_choice = (("1", "모집안함"), ("2", "모집중"), ("3", "서류 진행"),
("4", "면접 진행"), ("5", "회비 입금 대기 중"))
states = models.CharField(max_length=15,
choices=states_choice,
default="1")
club_in = models.JSONField()
objects = models.DjongoManager()
class Club(models.Model):
cc_id = models.IntegerField(unique=True, primary_key=True, default=0)
name = models.CharField(max_length=15)
information = models.CharField(max_length=30, null=True)
category_choice = (("c1", "학술"), ("c2", "예술"), ("c3", "친목"), ("c4", "스포츠"),
("c5", "여행"), ("c6", "종교"), ("c7", "봉사"), ("c8", "기타"))
category = models.CharField(max_length=8,
choices=category_choice,
default="c1")
foundationdate = models.JSONField(default=None)
detail_information = models.TextField(max_length=300, default=None)
self_image = models.CharField(max_length=10, default=None)
card_image = models.JSONField(default=[])
telephone = models.CharField(max_length=15, default=None)
email = models.EmailField(default=None)
#status
objects = models.DjongoManager()
def __str__(self):
return str(self.cc_id)
class Club_introduce(models.Model):
number = models.CharField(max_length=5, default=None)
region = models.CharField(max_length=25, default=None)
target_choice = (("t1", "대학생"), ("t2", "직장인"), ("t3", "일반인"))
target = models.CharField(max_length=10,
choices=target_choice,
default="t1")
time = models.CharField(max_length=10, default=None)
mainURL = models.URLField(max_length=200, default=None)
detail = models.JSONField(default=[])
poster = models.CharField(max_length=5, default=None)
card_image = models.JSONField(default=[])
club_id = models.IntegerField(default=0)
type_choice = (("1", "면접전형"), ("2", "서류전형"), ("3", "면접+서류전형"))
types = models.CharField(max_length=20, choices=type_choice, default="1")
ci_id = models.CharField(unique=True,
primary_key=True,
max_length=15,
default=0)
objects = models.DjongoManager()
class Breed(models.Model):
name = models.CharField(null=True, max_length=30)
slug = models.CharField(null=True, max_length=20)
restingMinutes = models.JSONField(default=list, blank=True, null=True)
restingPerDay = models.IntegerField(null=True)
restingPerWeek = models.IntegerField(null=True)
def __str__(self):
"{} - {} - {} - {} ".format(self.name, self.slug, self.restingMinutes,
self.restingMinutes, self.restingPerDay,
self.restingPerWeek)
class Payment(models.Model):
concept = models.CharField(
max_length=20, primary_key=True
) # Workarround to prevent issues, not really a primary Key
transactions = models.JSONField() # List
free_contracts = models.ArrayField(model_container=Contract)
class Meta:
managed = False
def __getitem__(self, name):
return getattr(self, name)
class Migration(migrations.Migration):
initial = True
dependencies: list = []
operations = [
migrations.CreateModel(
name='Antiphona',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('text',
djongo_models.JSONField(
default={},
validators=[
antiphona.validators.TypeValidator(dict),
antiphona.validators.KeysTypeValidator(str),
antiphona.validators.ValuesTypeValidator(str),
antiphona.validators.ValidKeyValidator(valid_keys={
'en_US', 'es_US', 'es_ES', 'es_AR', 'la', 'es_MX'
}, ),
])),
('link', models.URLField()),
],
),
migrations.CreateModel(
name='Celebration',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('liturgical_season',
models.CharField(
choices=[('advent', 'Advent'), ('christmas', 'Christmas'),
('lent', 'Lent'), ('easter', 'Easter'),
('ordinary', 'Ordinary Time')],
max_length=9,
)),
('name', models.CharField(max_length=40)),
('antiphonas',
djongo_models.ArrayReferenceField(
on_delete=deletion.DO_NOTHING,
to='antiphona.Antiphona',
)),
],
),
]
