# This is an auto-generated Django model module.

# You'll have to do the following manually to clean this up:

# * Rearrange models' order

# * Make sure each model has one field with primary_key=True

# Feel free to rename the models, but don't rename db_table values or field names.

#

# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'

# into your database.

from django.db import models

class Acronym(models.Model):

acronym_id = models.IntegerField(primary_key=True)

acronym = models.CharField(unique=True, blank=True, maxlength=12)

name = models.CharField(unique=True, maxlength=100)

name_key = models.CharField(maxlength=50)

class Meta:

db_table = 'acronym'

class AgendaCat(models.Model):

agenda_cat_id = models.IntegerField(primary_key=True)

agenda_cat_value = models.CharField(blank=True, maxlength=100)

class Meta:

db_table = 'agenda_cat'

class AgendaItems(models.Model):

agenda_item_id = models.IntegerField(primary_key=True)

telechat_id = models.IntegerField()

agenda_cat_id = models.IntegerField(null=True, blank=True)

ballot_id = models.IntegerField()

group_acronym_id = models.IntegerField()

agenda_item_status_id = models.IntegerField(null=True, blank=True)

iana_note = models.TextField(blank=True)

other_note = models.TextField(blank=True)

agenda_note_cat_id = models.IntegerField(null=True, blank=True)

note_draft_by = models.IntegerField(null=True, blank=True)

item_num = models.IntegerField(null=True, blank=True)

total_num = models.IntegerField(null=True, blank=True)

agenda_item_gr_status_id = models.IntegerField(null=True, blank=True)

wg_action_status = models.IntegerField(null=True, blank=True)

wg_action_status_sub = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'agenda_items'

class AllId(models.Model):

id_document_tag = models.IntegerField(primary_key=True)

filename = models.CharField(blank=True, maxlength=100)

last_active_revision = models.CharField(blank=True, maxlength=2)

class Meta:

db_table = 'all_id'

class AnnouncedFrom(models.Model):

announced_from_id = models.IntegerField(primary_key=True)

announced_from_value = models.CharField(blank=True, maxlength=255)

announced_from_email = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'announced_from'

class AnnouncedFromPermission(models.Model):

id = models.IntegerField(primary_key=True)

announcedfrom_id = models.IntegerField(unique=True)

permission_id = models.IntegerField(unique=True)

class Meta:

db_table = 'announced_from_permission'

class AnnouncedTo(models.Model):

announced_to_id = models.IntegerField(primary_key=True)

announced_to_value = models.CharField(blank=True, maxlength=255)

announced_to_email = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'announced_to'

class Announcements(models.Model):

announcement_id = models.IntegerField(primary_key=True)

announced_by = models.IntegerField()

announced_date = models.DateField(null=True, blank=True)

announced_time = models.CharField(blank=True, maxlength=20)

announcement_text = models.TextField(blank=True)

announced_from_id = models.IntegerField(null=True, blank=True)

cc = models.CharField(blank=True, maxlength=255)

subject = models.CharField(blank=True, maxlength=255)

extra = models.TextField(blank=True)

announced_to_id = models.IntegerField(null=True, blank=True)

nomcom = models.IntegerField(null=True, blank=True)

nomcom_chair_id = models.IntegerField(null=True, blank=True)

manualy_added = models.IntegerField(null=True, blank=True)

other_val = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'announcements'

class AreaDirectors(models.Model):

id = models.IntegerField(primary_key=True)

area_acronym_id = models.IntegerField(unique=True, null=True, blank=True)

person_or_org_tag = models.IntegerField(unique=True)

class Meta:

db_table = 'area_directors'

class AreaGroup(models.Model):

id = models.IntegerField(primary_key=True)

area_acronym_id = models.IntegerField(unique=True)

group_acronym_id = models.IntegerField(unique=True)

class Meta:

db_table = 'area_group'

class AreaStatus(models.Model):

status_id = models.IntegerField(primary_key=True)

status_value = models.CharField(maxlength=25)

class Meta:

db_table = 'area_status'

class Areas(models.Model):

area_acronym_id = models.IntegerField(primary_key=True)

start_date = models.DateField()

concluded_date = models.DateField(null=True, blank=True)

status_id = models.IntegerField()

comments = models.TextField(blank=True)

last_modified_date = models.DateField()

extra_email_addresses = models.TextField(blank=True)

area_coordinator_tag = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'areas'

class AuthGroup(models.Model):

id = models.IntegerField(primary_key=True)

name = models.CharField(unique=True, maxlength=80)

class Meta:

db_table = 'auth_group'

class AuthGroupPermissions(models.Model):

id = models.IntegerField(primary_key=True)

group_id = models.IntegerField(unique=True)

permission_id = models.IntegerField(unique=True)

class Meta:

db_table = 'auth_group_permissions'

class AuthMessage(models.Model):

id = models.IntegerField(primary_key=True)

user_id = models.IntegerField()

message = models.TextField()

class Meta:

db_table = 'auth_message'

class AuthPermission(models.Model):

id = models.IntegerField(primary_key=True)

name = models.CharField(maxlength=50)

content_type_id = models.IntegerField()

codename = models.CharField(unique=True, maxlength=100)

class Meta:

db_table = 'auth_permission'

class AuthUser(models.Model):

id = models.IntegerField(primary_key=True)

username = models.CharField(unique=True, maxlength=30)

first_name = models.CharField(maxlength=30)

last_name = models.CharField(maxlength=30)

email = models.CharField(maxlength=75)

password = models.CharField(maxlength=128)

is_staff = models.IntegerField()

is_active = models.IntegerField()

is_superuser = models.IntegerField()

last_login = models.DateTimeField()

date_joined = models.DateTimeField()

class Meta:

db_table = 'auth_user'

class AuthUserGroups(models.Model):

id = models.IntegerField(primary_key=True)

user_id = models.IntegerField(unique=True)

group_id = models.IntegerField(unique=True)

class Meta:

db_table = 'auth_user_groups'

class AuthUserUserPermissions(models.Model):

id = models.IntegerField(primary_key=True)

user_id = models.IntegerField(unique=True)

permission_id = models.IntegerField(unique=True)

class Meta:

db_table = 'auth_user_user_permissions'

class BallotInfo(models.Model):

ballot_id = models.IntegerField(primary_key=True)

active = models.IntegerField()

an_sent = models.IntegerField()

an_sent_date = models.DateField(null=True, blank=True)

an_sent_by = models.IntegerField(null=True, blank=True)

defer = models.IntegerField(null=True, blank=True)

defer_by = models.IntegerField(null=True, blank=True)

defer_date = models.DateField(null=True, blank=True)

approval_text = models.TextField(blank=True)

last_call_text = models.TextField(blank=True)

ballot_writeup = models.TextField(blank=True)

ballot_issued = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'ballot_info'

class Ballots(models.Model):

id = models.IntegerField(primary_key=True)

ballot_id = models.IntegerField(unique=True)

ad_id = models.IntegerField(unique=True)

yes_col = models.IntegerField()

no_col = models.IntegerField()

abstain = models.IntegerField()

approve = models.IntegerField()

discuss = models.IntegerField()

recuse = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'ballots'

class BallotsComment(models.Model):

id = models.IntegerField(primary_key=True)

ballot_id = models.IntegerField(unique=True)

ad_id = models.IntegerField(unique=True)

comment_date = models.DateField()

revision = models.CharField(maxlength=2)

active = models.IntegerField()

comment_text = models.TextField(blank=True)

class Meta:

db_table = 'ballots_comment'

class BallotsDiscuss(models.Model):

id = models.IntegerField(primary_key=True)

ballot_id = models.IntegerField(unique=True)

ad_id = models.IntegerField(unique=True)

discuss_date = models.DateField()

revision = models.CharField(maxlength=2)

active = models.IntegerField()

discuss_text = models.TextField(blank=True)

class Meta:

db_table = 'ballots_discuss'

class BashAgenda(models.Model):

telechat_id = models.IntegerField(primary_key=True)

bash_agenda_txt = models.TextField(blank=True)

change_agenda = models.IntegerField(null=True, blank=True)

change_agenda_note = models.TextField(blank=True)

class Meta:

db_table = 'bash_agenda'

class Chairs(models.Model):

id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField()

chair_name = models.CharField(blank=True, maxlength=25)

class Meta:

db_table = 'chairs'

class ChairsHistory(models.Model):

id = models.IntegerField(primary_key=True)

chair_type_id = models.IntegerField(null=True, blank=True)

present_chair = models.IntegerField(null=True, blank=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

start_year = models.IntegerField(null=True, blank=True)

end_year = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'chairs_history'

class DjangoAdminLog(models.Model):

id = models.IntegerField(primary_key=True)

action_time = models.DateTimeField()

user_id = models.IntegerField()

content_type_id = models.IntegerField(null=True, blank=True)

object_id = models.TextField(blank=True)

object_repr = models.CharField(maxlength=200)

action_flag = models.IntegerField()

change_message = models.TextField()

class Meta:

db_table = 'django_admin_log'

class DjangoContentType(models.Model):

id = models.IntegerField(primary_key=True)

name = models.CharField(maxlength=100)

app_label = models.CharField(unique=True, maxlength=100)

model = models.CharField(unique=True, maxlength=100)

class Meta:

db_table = 'django_content_type'

class DjangoSession(models.Model):

session_key = models.CharField(maxlength=40, primary_key=True)

session_data = models.TextField()

expire_date = models.DateTimeField()

class Meta:

db_table = 'django_session'

class DjangoSite(models.Model):

id = models.IntegerField(primary_key=True)

domain = models.CharField(maxlength=100)

name = models.CharField(maxlength=50)

class Meta:

db_table = 'django_site'

class DocumentComments(models.Model):

id = models.IntegerField(primary_key=True)

document_id = models.IntegerField()

rfc_flag = models.IntegerField(null=True, blank=True)

public_flag = models.IntegerField(null=True, blank=True)

comment_date = models.DateField()

comment_time = models.CharField(maxlength=20)

version = models.CharField(blank=True, maxlength=3)

comment_text = models.TextField(blank=True)

created_by = models.IntegerField(null=True, blank=True)

result_state = models.IntegerField(null=True, blank=True)

origin_state = models.IntegerField(null=True, blank=True)

ballot = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'document_comments'

class DtRequest(models.Model):

id = models.IntegerField(primary_key=True)

description = models.CharField(maxlength=255)

request_by = models.IntegerField()

request_date = models.DateField(null=True, blank=True)

cur_version = models.CharField(blank=True, maxlength=5)

status = models.TextField(blank=True)

done_flag = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'dt_request'

class EmailAddresses(models.Model):

id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField()

email_type = models.CharField(maxlength=4)

email_priority = models.IntegerField()

email_address = models.CharField(blank=True, maxlength=255)

email_comment = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'email_addresses'

class FromBodies(models.Model):

from_id = models.IntegerField(primary_key=True)

body_name = models.CharField(blank=True, maxlength=35)

poc = models.IntegerField(null=True, blank=True)

is_liaison_manager = models.IntegerField(null=True, blank=True)

other_sdo = models.IntegerField(null=True, blank=True)

email_priority = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'from_bodies'

class GChairs(models.Model):

id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField(unique=True)

group_acronym_id = models.IntegerField(unique=True)

class Meta:

db_table = 'g_chairs'

class GEditors(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField(unique=True)

person_or_org_tag = models.IntegerField(unique=True)

class Meta:

db_table = 'g_editors'

class GSecretaries(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField(null=True, blank=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'g_secretaries'

class GSecretary(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField()

person_or_org_tag = models.IntegerField()

class Meta:

db_table = 'g_secretary'

class GStatus(models.Model):

status_id = models.IntegerField(primary_key=True)

status_value = models.CharField(maxlength=25)

class Meta:

db_table = 'g_status'

class GTechAdvisors(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField(unique=True)

person_or_org_tag = models.IntegerField(unique=True)

class Meta:

db_table = 'g_tech_advisors'

class GType(models.Model):

group_type_id = models.IntegerField(primary_key=True)

group_type = models.CharField(maxlength=25)

class Meta:

db_table = 'g_type'

class GeneralInfo(models.Model):

id = models.IntegerField(primary_key=True)

info_name = models.CharField(blank=True, maxlength=50)

info_text = models.TextField(blank=True)

info_header = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'general_info'

class GoalsMilestones(models.Model):

gm_id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField()

description = models.TextField(blank=True)

expected_due_date = models.DateField(null=True, blank=True)

done_date = models.DateField(null=True, blank=True)

done = models.CharField(blank=True, maxlength=4)

last_modified_date = models.DateField()

class Meta:

db_table = 'goals_milestones'

class GroupFlag(models.Model):

group_flag = models.IntegerField(primary_key=True)

group_flag_val = models.CharField(blank=True, maxlength=30)

equiv_doc_state_id = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'group_flag'

class GroupInternal(models.Model):

group_acronym_id = models.IntegerField(unique=True)

note = models.TextField(blank=True)

status_date = models.DateField(null=True, blank=True)

agenda = models.IntegerField(null=True, blank=True)

token_name = models.CharField(blank=True, maxlength=25)

pwg_cat_id = models.IntegerField(null=True, blank=True)

telechat_date = models.DateField(null=True, blank=True)

class Meta:

db_table = 'group_internal'

class GroupsIetf(models.Model):

group_acronym_id = models.IntegerField(primary_key=True)

group_type_id = models.IntegerField()

proposed_date = models.DateField(null=True, blank=True)

start_date = models.DateField(null=True, blank=True)

dormant_date = models.DateField(null=True, blank=True)

concluded_date = models.DateField(null=True, blank=True)

status_id = models.IntegerField()

area_director_id = models.IntegerField(null=True, blank=True)

meeting_scheduled = models.CharField(blank=True, maxlength=3)

email_address = models.CharField(blank=True, maxlength=60)

email_subscribe = models.CharField(blank=True, maxlength=120)

email_keyword = models.CharField(blank=True, maxlength=50)

email_archive = models.CharField(blank=True, maxlength=95)

comments = models.TextField(blank=True)

last_modified_date = models.DateField()

meeting_scheduled_old = models.CharField(blank=True, maxlength=3)

class Meta:

db_table = 'groups_ietf'

class HitCounter(models.Model):

id = models.IntegerField(primary_key=True)

page_name = models.CharField(blank=True, maxlength=255)

hit_count = models.IntegerField(null=True, blank=True)

last_visitor = models.CharField(blank=True, maxlength=255)

last_visited_date = models.DateField(null=True, blank=True)

class Meta:

db_table = 'hit_counter'

class IdApprovedDetail(models.Model):

id = models.IntegerField(primary_key=True)

filename = models.CharField(blank=True, maxlength=255)

approved_status = models.IntegerField(null=True, blank=True)

approved_person_tag = models.IntegerField(null=True, blank=True)

approved_date = models.DateField(null=True, blank=True)

recorded_by = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'id_approved_detail'

class IdAuthors(models.Model):

id = models.IntegerField(primary_key=True)

id_document_tag = models.IntegerField(unique=True)

person_or_org_tag = models.IntegerField(unique=True)

author_order = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'id_authors'

class IdDates(models.Model):

id = models.IntegerField(primary_key=True)

id_date = models.DateField(null=True, blank=True)

date_name = models.CharField(blank=True, maxlength=255)

f_name = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'id_dates'

class IdIntendedStatus(models.Model):

intended_status_id = models.IntegerField(primary_key=True)

status_value = models.CharField(maxlength=25)

class Meta:

db_table = 'id_intended_status'

class IdInternal(models.Model):

id_document_tag = models.IntegerField(unique=True)

rfc_flag = models.IntegerField(null=True, blank=True)

ballot_id = models.IntegerField()

primary_flag = models.IntegerField(null=True, blank=True)

group_flag = models.IntegerField()

token_name = models.CharField(blank=True, maxlength=25)

token_email = models.CharField(blank=True, maxlength=255)

note = models.TextField(blank=True)

status_date = models.DateField(null=True, blank=True)

email_display = models.CharField(blank=True, maxlength=50)

agenda = models.IntegerField(null=True, blank=True)

cur_state = models.IntegerField()

prev_state = models.IntegerField()

assigned_to = models.CharField(blank=True, maxlength=25)

mark_by = models.IntegerField()

job_owner = models.IntegerField()

event_date = models.DateField(null=True, blank=True)

area_acronym_id = models.IntegerField()

cur_sub_state_id = models.IntegerField(null=True, blank=True)

prev_sub_state_id = models.IntegerField(null=True, blank=True)

returning_item = models.IntegerField(null=True, blank=True)

telechat_date = models.DateField(null=True, blank=True)

via_rfc_editor = models.IntegerField(null=True, blank=True)

state_change_notice_to = models.CharField(blank=True, maxlength=255)

dnp = models.IntegerField(null=True, blank=True)

dnp_date = models.DateField(null=True, blank=True)

noproblem = models.IntegerField(null=True, blank=True)

resurrect_requested_by = models.IntegerField(null=True, blank=True)

approved_in_minute = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'id_internal'

class IdRestrictedWord(models.Model):

id = models.IntegerField(primary_key=True)

restricted_word = models.CharField(maxlength=25)

class Meta:

db_table = 'id_restricted_word'

class IdStatus(models.Model):

status_id = models.IntegerField(primary_key=True)

status_value = models.CharField(maxlength=25)

class Meta:

db_table = 'id_status'

class IdSubmissionDetail(models.Model):

submission_id = models.IntegerField(primary_key=True)

temp_id_document_tag = models.IntegerField(null=True, blank=True)

status_id = models.IntegerField(null=True, blank=True)

last_updated_date = models.DateField(null=True, blank=True)

last_updated_time = models.CharField(blank=True, maxlength=25)

id_document_name = models.CharField(blank=True, maxlength=255)

group_acronym_id = models.IntegerField(null=True, blank=True)

filename = models.CharField(blank=True, maxlength=255)

creation_date = models.DateField(null=True, blank=True)

submission_date = models.DateField(null=True, blank=True)

remote_ip = models.CharField(blank=True, maxlength=100)

revision = models.CharField(blank=True, maxlength=3)

submitter_tag = models.IntegerField(null=True, blank=True)

auth_key = models.CharField(blank=True, maxlength=255)

idnits_message = models.TextField(blank=True)

file_type = models.CharField(blank=True, maxlength=50)

comment_to_sec = models.TextField(blank=True)

abstract = models.TextField(blank=True)

txt_page_count = models.IntegerField(null=True, blank=True)

error_message = models.CharField(blank=True, maxlength=255)

warning_message = models.TextField(blank=True)

wg_submission = models.IntegerField(null=True, blank=True)

filesize = models.IntegerField(null=True, blank=True)

man_posted_date = models.DateField(null=True, blank=True)

man_posted_by = models.CharField(blank=True, maxlength=255)

first_two_pages = models.TextField(blank=True)

sub_email_priority = models.IntegerField(null=True, blank=True)

invalid_version = models.IntegerField(null=True, blank=True)

idnits_failed = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'id_submission_detail'

class IdSubmissionEnv(models.Model):

max_live = models.IntegerField(null=True, blank=True)

staging_path = models.CharField(blank=True, maxlength=255)

max_interval = models.IntegerField(null=True, blank=True)

current_manual_proc_date = models.IntegerField(null=True, blank=True)

init_rev_approved_msg = models.TextField(blank=True)

submitter_auth_msg = models.TextField(blank=True)

id_action_announcement = models.TextField(blank=True)

target_path_web = models.CharField(blank=True, maxlength=255)

target_path_ftp = models.CharField(blank=True, maxlength=255)

side_bar_html = models.TextField(blank=True)

staging_url = models.CharField(blank=True, maxlength=255)

top_bar_html = models.TextField(blank=True)

bottom_bar_html = models.TextField(blank=True)

id_approval_request_msg = models.TextField(blank=True)

emerg_auto_response = models.IntegerField(null=True, blank=True)

max_same_draft_name = models.IntegerField(null=True, blank=True)

max_same_draft_size = models.IntegerField(null=True, blank=True)

max_same_submitter = models.IntegerField(null=True, blank=True)

max_same_submitter_size = models.IntegerField(null=True, blank=True)

max_same_wg_draft = models.IntegerField(null=True, blank=True)

max_same_wg_draft_size = models.IntegerField(null=True, blank=True)

max_daily_submission = models.IntegerField(null=True, blank=True)

max_daily_submission_size = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'id_submission_env'

class IdSubmissionStatus(models.Model):

status_id = models.IntegerField(primary_key=True)

status_value = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'id_submission_status'

class IdstUsers(models.Model):

id = models.IntegerField(primary_key=True)

login_name = models.CharField(maxlength=255)

password = models.CharField(blank=True, maxlength=255)

random_str = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'idst_users'

class IesgHistory(models.Model):

id = models.IntegerField(primary_key=True)

meeting_num = models.IntegerField()

area_acronym_id = models.IntegerField()

person_or_org_tag = models.IntegerField()

class Meta:

db_table = 'iesg_history'

class IesgLogin(models.Model):

id = models.IntegerField(primary_key=True)

login_name = models.CharField(blank=True, maxlength=255)

password = models.CharField(maxlength=25)

user_level = models.IntegerField()

first_name = models.CharField(blank=True, maxlength=25)

last_name = models.CharField(blank=True, maxlength=25)

person_or_org_tag = models.IntegerField(null=True, blank=True)

pgp_id = models.CharField(blank=True, maxlength=20)

default_search = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'iesg_login'

class IesgPassword(models.Model):

person_or_org_tag = models.IntegerField(primary_key=True)

login_name = models.CharField(blank=True, maxlength=255)

password = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'iesg_password'

class IetfauthUsermap(models.Model):

id = models.IntegerField(primary_key=True)

user_id = models.IntegerField(unique=True)

person_id = models.IntegerField(unique=True)

class Meta:

db_table = 'ietfauth_usermap'

class ImportedMailingList(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField(null=True, blank=True)

list_acronym = models.CharField(blank=True, maxlength=255)

list_name = models.CharField(blank=True, maxlength=255)

list_domain = models.CharField(blank=True, maxlength=25)

class Meta:

db_table = 'imported_mailing_list'

class InterimInfo(models.Model):

id = models.IntegerField(primary_key=True)

group_acronym_id = models.IntegerField(null=True, blank=True)

meeting_num = models.IntegerField(null=True, blank=True)

meeting_date = models.CharField(blank=True, maxlength=255)

message_body = models.TextField(blank=True)

class Meta:

db_table = 'interim_info'

class InternetDrafts(models.Model):

id_document_tag = models.IntegerField(primary_key=True)

id_document_name = models.CharField(blank=True, maxlength=255)

id_document_key = models.CharField(blank=True, maxlength=255)

group_acronym_id = models.IntegerField(null=True, blank=True)

filename = models.CharField(blank=True, maxlength=255)

revision = models.CharField(maxlength=2)

revision_date = models.DateField(null=True, blank=True)

file_type = models.CharField(blank=True, maxlength=20)

txt_page_count = models.IntegerField(null=True, blank=True)

local_path = models.CharField(blank=True, maxlength=255)

start_date = models.DateField(null=True, blank=True)

expiration_date = models.DateField(null=True, blank=True)

abstract = models.TextField(blank=True)

dunn_sent_date = models.DateField(null=True, blank=True)

extension_date = models.DateField(null=True, blank=True)

status_id = models.IntegerField()

intended_status_id = models.IntegerField()

lc_sent_date = models.DateField(null=True, blank=True)

lc_changes = models.CharField(blank=True, maxlength=3)

lc_expiration_date = models.DateField(null=True, blank=True)

b_sent_date = models.DateField(null=True, blank=True)

b_discussion_date = models.DateField(null=True, blank=True)

b_approve_date = models.DateField(null=True, blank=True)

wgreturn_date = models.DateField(null=True, blank=True)

rfc_number = models.IntegerField(null=True, blank=True)

comments = models.TextField(blank=True)

last_modified_date = models.DateField()

replaced_by = models.IntegerField(null=True, blank=True)

review_by_rfc_editor = models.IntegerField(null=True, blank=True)

expired_tombstone = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'internet_drafts'

class IprContacts(models.Model):

contact_id = models.IntegerField(primary_key=True)

ipr_id = models.IntegerField(null=True, blank=True)

contact_type = models.IntegerField(null=True, blank=True)

name = models.CharField(blank=True, maxlength=255)

title = models.CharField(blank=True, maxlength=255)

department = models.CharField(blank=True, maxlength=255)

telephone = models.CharField(blank=True, maxlength=25)

fax = models.CharField(blank=True, maxlength=25)

email = models.CharField(blank=True, maxlength=255)

address1 = models.CharField(blank=True, maxlength=255)

address2 = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'ipr_contacts'

class IprDetail(models.Model):

ipr_id = models.IntegerField(primary_key=True)

p_h_legal_name = models.CharField(blank=True, maxlength=255)

document_title = models.CharField(blank=True, maxlength=255)

rfc_number = models.IntegerField(null=True, blank=True)

id_document_tag = models.IntegerField(null=True, blank=True)

other_designations = models.CharField(blank=True, maxlength=255)

p_applications = models.CharField(blank=True, maxlength=255)

date_applied = models.CharField(blank=True, maxlength=255)

selecttype = models.CharField(blank=True, maxlength=3)

disclouser_identify = models.CharField(blank=True, maxlength=255)

licensing_option = models.IntegerField(null=True, blank=True)

other_notes = models.TextField(blank=True)

submitted_date = models.DateField(null=True, blank=True)

status = models.IntegerField(null=True, blank=True)

comments = models.TextField(blank=True)

old_ipr_url = models.CharField(blank=True, maxlength=255)

additional_old_title1 = models.CharField(blank=True, maxlength=255)

additional_old_url1 = models.CharField(blank=True, maxlength=255)

additional_old_title2 = models.CharField(blank=True, maxlength=255)

additional_old_url2 = models.CharField(blank=True, maxlength=255)

country = models.CharField(blank=True, maxlength=100)

p_notes = models.TextField(blank=True)

third_party = models.IntegerField(null=True, blank=True)

lic_opt_a_sub = models.IntegerField(null=True, blank=True)

lic_opt_b_sub = models.IntegerField(null=True, blank=True)

lic_opt_c_sub = models.IntegerField(null=True, blank=True)

generic = models.IntegerField(null=True, blank=True)

selectowned = models.CharField(blank=True, maxlength=3)

comply = models.IntegerField(null=True, blank=True)

lic_checkbox = models.IntegerField(null=True, blank=True)

update_notified_date = models.DateField(null=True, blank=True)

class Meta:

db_table = 'ipr_detail'

class IprIds(models.Model):

id = models.IntegerField(primary_key=True)

id_document_tag = models.IntegerField(null=True, blank=True)

ipr_id = models.IntegerField(null=True, blank=True)

revision = models.CharField(blank=True, maxlength=2)

class Meta:

db_table = 'ipr_ids'

class IprLicensing(models.Model):

licensing_option = models.IntegerField(primary_key=True)

licensing_option_value = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'ipr_licensing'

class IprNotifications(models.Model):

id = models.IntegerField(primary_key=True)

ipr_id = models.IntegerField(null=True, blank=True)

notification = models.TextField(blank=True)

date_sent = models.DateField(null=True, blank=True)

time_sent = models.CharField(blank=True, maxlength=25)

class Meta:

db_table = 'ipr_notifications'

class IprRfcs(models.Model):

id = models.IntegerField(primary_key=True)

ipr_id = models.IntegerField(null=True, blank=True)

rfc_number = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'ipr_rfcs'

class IprSelecttype(models.Model):

type_id = models.IntegerField(primary_key=True)

selecttype = models.IntegerField(null=True, blank=True)

type_display = models.CharField(blank=True, maxlength=15)

class Meta:

db_table = 'ipr_selecttype'

class IprUpdates(models.Model):

id = models.IntegerField(primary_key=True)

ipr_id = models.IntegerField(null=True, blank=True)

updated = models.IntegerField(null=True, blank=True)

status_to_be = models.IntegerField(null=True, blank=True)

processed = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'ipr_updates'

class Irtf(models.Model):

irtf_id = models.IntegerField(primary_key=True)

irtf_acronym = models.CharField(blank=True, maxlength=25)

irtf_name = models.CharField(blank=True, maxlength=255)

charter_text = models.TextField(blank=True)

meeting_scheduled = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'irtf'

class IrtfChairs(models.Model):

id = models.IntegerField(primary_key=True)

irtf_id = models.IntegerField(null=True, blank=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'irtf_chairs'

class LiaisonDetail(models.Model):

detail_id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

submitted_date = models.DateField(null=True, blank=True)

last_modified_date = models.DateField(null=True, blank=True)

from_id = models.IntegerField(null=True, blank=True)

to_body = models.CharField(blank=True, maxlength=255)

title = models.CharField(blank=True, maxlength=255)

response_contact = models.CharField(blank=True, maxlength=255)

technical_contact = models.CharField(blank=True, maxlength=255)

purpose = models.TextField(blank=True)

body = models.TextField(blank=True)

deadline_date = models.DateField(null=True, blank=True)

cc1 = models.TextField(blank=True)

cc2 = models.CharField(blank=True, maxlength=50)

submitter_name = models.CharField(blank=True, maxlength=255)

submitter_email = models.CharField(blank=True, maxlength=255)

by_secretariat = models.IntegerField(null=True, blank=True)

to_poc = models.CharField(blank=True, maxlength=255)

to_email = models.CharField(blank=True, maxlength=255)

purpose_id = models.IntegerField(null=True, blank=True)

replyto = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'liaison_detail'

class LiaisonDetailTemp(models.Model):

detail_id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

submitted_date = models.DateField(null=True, blank=True)

last_modified_date = models.DateField(null=True, blank=True)

from_id = models.IntegerField(null=True, blank=True)

to_body = models.CharField(blank=True, maxlength=255)

title = models.CharField(blank=True, maxlength=255)

response_contact = models.CharField(blank=True, maxlength=255)

technical_contact = models.CharField(blank=True, maxlength=255)

purpose = models.TextField(blank=True)

body = models.TextField(blank=True)

deadline_date = models.DateField(null=True, blank=True)

cc1 = models.TextField(blank=True)

cc2 = models.CharField(blank=True, maxlength=50)

to_poc = models.CharField(blank=True, maxlength=255)

to_email = models.CharField(blank=True, maxlength=255)

purpose_id = models.IntegerField(null=True, blank=True)

replyto = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'liaison_detail_temp'

class LiaisonManagers(models.Model):

id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

email_priority = models.IntegerField(null=True, blank=True)

sdo_id = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'liaison_managers'

class LiaisonPurpose(models.Model):

purpose_id = models.IntegerField(primary_key=True)

purpose_text = models.CharField(blank=True, maxlength=50)

class Meta:

db_table = 'liaison_purpose'

class LiaisonsInterim(models.Model):

id = models.IntegerField(primary_key=True)

title = models.CharField(blank=True, maxlength=255)

submitter_name = models.CharField(blank=True, maxlength=255)

submitter_email = models.CharField(blank=True, maxlength=255)

submitted_date = models.DateField(null=True, blank=True)

from_id = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'liaisons_interim'

class LiaisonsMembers(models.Model):

id = models.IntegerField(primary_key=True)

person_or_org_tag = models.IntegerField(null=True, blank=True)

affiliation = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'liaisons_members'

class MailingList(models.Model):

mailing_list_id = models.CharField(maxlength=25, primary_key=True)

request_date = models.DateField(null=True, blank=True)

mlist_name = models.CharField(blank=True, maxlength=250)

short_desc = models.CharField(blank=True, maxlength=250)

long_desc = models.TextField(blank=True)

requestor = models.CharField(blank=True, maxlength=250)

requestor_email = models.CharField(blank=True, maxlength=250)

admins = models.CharField(blank=True, maxlength=250)

archive_remote = models.TextField(blank=True)

archive_private = models.IntegerField(null=True, blank=True)

initial = models.TextField(blank=True)

welcome_message = models.TextField(blank=True)

subscription = models.IntegerField(null=True, blank=True)

post_who = models.IntegerField(null=True, blank=True)

post_admin = models.IntegerField(null=True, blank=True)

add_comment = models.TextField(blank=True)

mail_type = models.IntegerField(null=True, blank=True)

mail_cat = models.IntegerField(null=True, blank=True)

auth_person_or_org_tag = models.IntegerField(null=True, blank=True)

welcome_new = models.TextField(blank=True)

approved = models.IntegerField(null=True, blank=True)

approved_date = models.DateField(null=True, blank=True)

reason_to_delete = models.TextField(blank=True)

domain_name = models.CharField(blank=True, maxlength=10)

class Meta:

db_table = 'mailing_list'

class MailinglistsDomain(models.Model):

id = models.IntegerField(primary_key=True)

domain = models.CharField(maxlength=100)

class Meta:

db_table = 'mailinglists_domain'

class MailinglistsDomainApprovers(models.Model):

id = models.IntegerField(primary_key=True)

domain_id = models.IntegerField(unique=True)

role_id = models.IntegerField(unique=True)

class Meta:

db_table = 'mailinglists_domain_approvers'

class ManagementIssues(models.Model):

id = models.IntegerField(primary_key=True)

telechat_id = models.IntegerField(null=True, blank=True)

title = models.CharField(blank=True, maxlength=255)

issue = models.TextField(blank=True)

discussed_status_id = models.IntegerField(null=True, blank=True)

note = models.TextField(blank=True)

class Meta:

db_table = 'management_issues'

class MeetingAgendaCount(models.Model):

hit_count = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'meeting_agenda_count'

class MeetingAttendees(models.Model):

id = models.IntegerField(primary_key=True)

first_name = models.CharField(blank=True, maxlength=255)

last_name = models.CharField(blank=True, maxlength=255)

affiliated_company = models.CharField(blank=True, maxlength=255)

email_address = models.CharField(blank=True, maxlength=255)

meeting_num = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'meeting_attendees'

class MeetingHours(models.Model):

hour_id = models.IntegerField(primary_key=True)

hour_desc = models.CharField(blank=True, maxlength=20)

class Meta:

db_table = 'meeting_hours'

class MeetingRooms(models.Model):

room_id = models.IntegerField(primary_key=True)

meeting_num = models.IntegerField(null=True, blank=True)

room_name = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'meeting_rooms'

class MeetingTimes(models.Model):

time_id = models.IntegerField(primary_key=True)

time_desc = models.CharField(blank=True, maxlength=100)

meeting_num = models.IntegerField(null=True, blank=True)

day_id = models.IntegerField(null=True, blank=True)

session_name_id = models.IntegerField(null=True, blank=True)

class Meta:

db_table = 'meeting_times'

class MeetingVenues(models.Model):

id = models.IntegerField(primary_key=True)

meeting_num = models.IntegerField(null=True, blank=True)

break_area_name = models.CharField(blank=True, maxlength=255)

reg_area_name = models.CharField(blank=True, maxlength=255)

class Meta:

db_table = 'meeting_venues'

class Meetings(models.Model):

meeting_num = models.IntegerField(primary_key=True)

start_date = models.DateField(null=True, blank=True)

end_date = models.DateField(null=True, blank=True)

city = models.CharField(blank=True, maxlength=255)

state = models.CharField(blank=True, maxlength=255)

country = models.CharField(blank=True, maxlength=255)

ack = models.TextField(blank=True)

agenda_html = models.TextField(blank=True)

agenda_text = models.TextField(blank=True)

future_meeting = models.TextField(blank=True)

overview1 = models.TextField(blank=True)

overview2 = models.TextField(blank=True)

class Meta:

db_table = 'meetings'

class Messages(models.Model):

id = models.IntegerField(primary_key=True)

message_name = models.CharField(maxlength=25)

message_content = models.TextField()

recipient = models.CharField(maxlength=100)

class Meta:

db_table = 'messages'

class MigrateStat(models.Model):

id = models.IntegerField(primary_key=True)

new_script = models.CharField(maxlength=40)