d

Tables (67)

account_emailaddress

  • id — serial
  • email — varchar(254) — NOT NULL
  • verified — boolean — NOT NULL
  • primary — boolean — NOT NULL
  • user_id — bigint — NOT NULL

account_emailconfirmation

  • id — serial
  • created — timestamp — NOT NULL
  • sent — timestamp
  • email_address_id — integer — NOT NULL

address

  • id — bigserial
  • b_code — varchar(15) — NOT NULL
  • addr_lv1 — varchar(15) — NOT NULL
  • addr_lv2 — varchar(15)
  • addr_lv3 — varchar(15)
  • addr_lv4 — varchar(15)
  • start_date — date
  • end_date — date
  • start_date_str — varchar(20)
  • end_date_str — varchar(20)
  • latitude — double
  • longitude — double

auth_group

  • id — serial
  • name — varchar(150) — NOT NULL

auth_group_permissions

  • id — bigserial
  • group_id — integer — NOT NULL
  • permission_id — integer — NOT NULL

auth_permission

  • id — serial
  • name — varchar(255) — NOT NULL
  • content_type_id — integer — NOT NULL
  • codename — varchar(100) — NOT NULL

authtoken_token

  • created — timestamp — NOT NULL
  • user_id — bigint — NOT NULL

capacity_expected_price

  • id — bigserial
  • region — varchar(20) — NOT NULL
  • min_price — double
  • max_price — double
  • avg_price — double
  • capacity_range_id — bigint

capacity_price

  • id — bigserial
  • region — varchar(20) — NOT NULL
  • type — varchar(20) — NOT NULL
  • capacity_1 — double
  • capacity_2 — double
  • capacity_3 — double
  • capacity_4 — double
  • capacity_5 — double
  • capacity_6 — double
  • capacity_7 — double
  • capacity_8 — double
  • capacity_9 — double

capacity_range

  • id — bigserial
  • range — varchar

chat_message

  • id — bigserial
  • context — text — NOT NULL
  • send_datetime — timestamp — NOT NULL
  • chat_room_id — bigint — NOT NULL
  • sender_id — bigint — NOT NULL
  • read_count — integer — NOT NULL
  • receiver_id — bigint — NOT NULL

chat_room

  • id — bigserial
  • name — varchar(128) — NOT NULL
  • connect_count — integer — NOT NULL

chatting_room

  • id — bigserial
  • plant_id — bigint
  • user_buyer — bigint
  • user_seller — bigint

desired_price

  • id — bigint — NOT NULL
  • price — bigint — NOT NULL
  • type — varchar(16) — NOT NULL
  • created_datetime — timestamp — NOT NULL
  • plant_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

django_admin_log

  • id — serial
  • action_time — timestamp — NOT NULL
  • object_id — text
  • object_repr — varchar(200) — NOT NULL
  • action_flag — smallint — NOT NULL
  • change_message — text — NOT NULL
  • content_type_id — integer
  • user_id — bigint — NOT NULL

django_celery_beat_clockedschedule

  • id — serial
  • clocked_time — timestamp — NOT NULL

django_celery_beat_crontabschedule

  • id — serial
  • minute — varchar(240) — NOT NULL
  • hour — varchar(96) — NOT NULL
  • day_of_week — varchar(64) — NOT NULL
  • day_of_month — varchar(124) — NOT NULL
  • month_of_year — varchar(64) — NOT NULL
  • timezone — varchar(63) — NOT NULL

django_celery_beat_intervalschedule

  • id — serial
  • every — integer — NOT NULL
  • period — varchar(24) — NOT NULL

django_celery_beat_periodictask

  • id — serial
  • name — varchar(200) — NOT NULL
  • task — varchar(200) — NOT NULL
  • args — text — NOT NULL
  • kwargs — text — NOT NULL
  • queue — varchar(200)
  • exchange — varchar(200)
  • routing_key — varchar(200)
  • expires — timestamp
  • enabled — boolean — NOT NULL
  • last_run_at — timestamp
  • total_run_count — integer — NOT NULL
  • date_changed — timestamp — NOT NULL
  • description — text — NOT NULL
  • crontab_id — integer
  • interval_id — integer
  • solar_id — integer
  • one_off — boolean — NOT NULL
  • start_time — timestamp
  • priority — integer
  • headers — text — NOT NULL
  • clocked_id — integer
  • expire_seconds — integer

django_celery_beat_periodictasks

  • ident — smallint — NOT NULL
  • last_update — timestamp — NOT NULL

django_celery_beat_solarschedule

  • id — serial
  • event — varchar(24) — NOT NULL
  • latitude — numeric(9, 6) — NOT NULL
  • longitude — numeric(9, 6) — NOT NULL

django_celery_results_chordcounter

  • id — serial
  • group_id — varchar(255) — NOT NULL
  • sub_tasks — text — NOT NULL
  • count — integer — NOT NULL

django_celery_results_groupresult

  • id — serial
  • group_id — varchar(255) — NOT NULL
  • date_created — timestamp — NOT NULL
  • date_done — timestamp — NOT NULL
  • content_type — varchar(128) — NOT NULL
  • content_encoding — varchar(64) — NOT NULL
  • result — text

django_celery_results_taskresult

  • id — serial
  • task_id — varchar(255) — NOT NULL
  • status — varchar(50) — NOT NULL
  • content_type — varchar(128) — NOT NULL
  • content_encoding — varchar(64) — NOT NULL
  • result — text
  • date_done — timestamp — NOT NULL
  • traceback — text
  • meta — text
  • task_args — text
  • task_kwargs — text
  • task_name — varchar(255)
  • worker — varchar(100)
  • date_created — timestamp — NOT NULL
  • periodic_task_name — varchar(255)

django_content_type

  • id — serial
  • app_label — varchar(100) — NOT NULL
  • model — varchar(100) — NOT NULL

django_migrations

  • id — bigserial
  • app — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • applied — timestamp — NOT NULL

django_session

  • session_key — varchar(40) — NOT NULL
  • session_data — text — NOT NULL
  • expire_date — timestamp — NOT NULL

django_site

  • id — serial
  • domain — varchar(100) — NOT NULL
  • name — varchar(50) — NOT NULL

gen_hour_daily

  • id — integer — NOT NULL
  • gen_hour — text

gen_hour_yearly

  • id — integer — NOT NULL
  • mon1 — double
  • mon2 — double
  • mon3 — double
  • mon4 — double
  • mon5 — double
  • mon6 — double
  • mon7 — double
  • mon8 — double
  • mon9 — double
  • mon10 — double
  • mon11 — double
  • mon12 — double
  • rank — double
  • gen_hour — text

land_category

  • id — bigserial
  • name — varchar(32) — NOT NULL
  • code — varchar(8) — NOT NULL

land_trade_info

  • id — bigserial
  • price — integer — NOT NULL
  • area — double — NOT NULL
  • trade_datetime — date — NOT NULL
  • sigungu_code — varchar(5) — NOT NULL
  • sigungu_name — varchar(32)
  • bubjungdong — varchar(32)
  • usage_area — varchar(32)
  • land_category_name — varchar(16)
  • land_category_id — bigint

local_expected_price

  • id — bigserial
  • local — varchar(20) — NOT NULL
  • min_price — double
  • max_price — double
  • avg_price — double

local_price

  • id — bigserial
  • local — varchar(20) — NOT NULL
  • min_price — double
  • max_price — double
  • avg_price — double

message

  • id — bigserial
  • plant_id — bigint — NOT NULL
  • create_datetime — timestamp — NOT NULL
  • message_user_1_id — bigint — NOT NULL
  • message_user_2_id — bigint

message_content

  • id — bigserial
  • content — text — NOT NULL
  • send_datetime — timestamp — NOT NULL
  • check_datetime — timestamp
  • message_id — bigint — NOT NULL
  • receiver_id — bigint
  • sender_id — bigint — NOT NULL

plant_image

  • id — bigint — NOT NULL
  • file — varchar(100)
  • create_datetime — timestamp — NOT NULL
  • update_datetime — timestamp
  • plant_info_id — bigint — NOT NULL
  • file_origin_name — varchar(128)

plant_info

  • id — bigint — NOT NULL
  • module_manufacture_company — varchar(64)
  • module_name — varchar(64)
  • module_capacity — double
  • module_nums — integer
  • inverter_manufacture_company — varchar(64)
  • inverter_name — varchar(64)
  • inverter_capacity — double
  • inverter_nums — integer
  • rps_power_gen_image — varchar(100)
  • renewable_certificate_image — varchar(100)
  • create_datetime — timestamp — NOT NULL
  • update_datetime — timestamp
  • plant_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • renewable_certificate_image_origin_name — varchar(128)
  • rps_power_gen_image_origin_name — varchar(128)

plant_land_info

  • renewable_plants_raw_id — bigint — NOT NULL
  • price — double
  • area — double
  • stdr_year — integer
  • land_category_id — bigint

plant_license_file

  • id — bigint — NOT NULL
  • image_url — varchar(100) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • user_id — bigint — NOT NULL

predict_gen

  • id — integer — NOT NULL
  • predict_generate_1 — text
  • predict_generate_2 — text
  • predict_generate_3 — text
  • updated_date — timestamp
  • predict_timestamp — timestamp

question

  • id — bigserial
  • question — text
  • register_datetime — timestamp
  • user_id — bigint — NOT NULL
  • question_type_id — bigint — NOT NULL
  • status — varchar(32) — NOT NULL
  • answer — text
  • answer_datetime — timestamp

question_type

  • id — bigserial
  • name — varchar(32) — NOT NULL
  • sort_ordering — integer — NOT NULL

rec

  • id — bigserial
  • trade_count — integer
  • close_price — double
  • trade_day — varchar(20)
  • created_at — timestamp — NOT NULL

renewable_plants_raw

  • id — bigserial
  • company_name — varchar(150)
  • plant_name — varchar(150)
  • power_num — numeric(3)
  • capacity — double
  • member_type — varchar(32)
  • dispatch — varchar(30)
  • power_type — varchar(30)
  • power_category — varchar(20)
  • business_type — varchar(30)
  • kpx_address — varchar(300)
  • addr_lv1 — varchar(30)
  • addr_lv2 — varchar(30)
  • addr_lv3 — varchar(30)
  • latitude — double
  • longitude — double
  • status — numeric(1)
  • updated_address — varchar(300)
  • reorg_address — varchar(300)
  • pnu — varchar(24)
  • completion_date — integer
  • tilt — double
  • azimuth — double
  • manager — varchar(50)
  • module — varchar(100)
  • inverter — varchar(100)
  • source — integer
  • use_bool — boolean — NOT NULL
  • migration_type — varchar(10)
  • is_public — boolean — NOT NULL
  • create_user — integer
  • create_datetime — timestamp
  • country_code — varchar(2)
  • altitude — double
  • height — double
  • turbine — varchar(100)
  • owner — integer
  • deleted_at — timestamp
  • expected_price — double
  • capacity_range_id — integer

s3_delete_file

  • id — bigserial
  • file_name — varchar(512) — NOT NULL
  • delete_datetime — timestamp — NOT NULL

smp

  • id — bigserial
  • region — varchar(20)
  • smp — double
  • created_at — timestamp — NOT NULL

socialaccount_socialaccount

  • id — serial
  • provider — varchar(30) — NOT NULL
  • uid — varchar(191) — NOT NULL
  • last_login — timestamp — NOT NULL
  • date_joined — timestamp — NOT NULL
  • extra_data — text — NOT NULL
  • user_id — bigint — NOT NULL

socialaccount_socialapp

  • id — serial
  • provider — varchar(30) — NOT NULL
  • name — varchar(40) — NOT NULL
  • client_id — varchar(191) — NOT NULL
  • secret — varchar(191) — NOT NULL

socialaccount_socialapp_sites

  • id — bigserial
  • socialapp_id — integer — NOT NULL
  • site_id — integer — NOT NULL

socialaccount_socialtoken

  • id — serial
  • token — text — NOT NULL
  • token_secret — text — NOT NULL
  • expires_at — timestamp
  • account_id — integer — NOT NULL
  • app_id — integer — NOT NULL

token_blacklist_blacklistedtoken

  • id — bigserial
  • blacklisted_at — timestamp — NOT NULL
  • token_id — bigint — NOT NULL

token_blacklist_outstandingtoken

  • id — bigserial
  • token — text — NOT NULL
  • created_at — timestamp
  • expires_at — timestamp — NOT NULL
  • user_id — bigint
  • jti — varchar(255) — NOT NULL

trade_info_rec

  • id — bigserial
  • bz_dd — date — NOT NULL
  • rn — integer
  • cls_prc — integer
  • trd_cnt — integer
  • trd_rec_value — integer
  • tot_cnt — integer
  • created_at — timestamp
  • tot_rec_value — bigint
  • bid_trd_val — bigint
  • land_hg_prc — integer
  • land_lw_prc — integer
  • land_ord_rec_value — bigint
  • land_trd_cnt — integer
  • land_trd_rec_value — bigint
  • land_ord_cnt — integer
  • land_avg_prc — integer
  • land_uplmt_prc — integer
  • land_lwlmt_prc — integer
  • jeju_ord_cnt — bigint
  • jeju_ord_rec_value — bigint
  • jeju_lwlmt_prc — integer
  • jeju_trd_cnt — integer
  • jeju_avg_prc — integer
  • jeju_hg_prc — integer
  • jeju_trd_rec_value — bigint
  • jeju_uplmt_prc — integer
  • jeju_lw_prc — integer

trade_info_smp

  • id — bigint — NOT NULL
  • jeju_smp — double — NOT NULL
  • land_smp — double — NOT NULL
  • trad_hour — integer — NOT NULL
  • trade_day — date — NOT NULL

trade_info_weighted_avg_smp_hourly

  • id — bigserial
  • trade_day — date — NOT NULL
  • trad_hour — integer — NOT NULL
  • jeju_weighted_avg_smp — double — NOT NULL
  • land_weighted_avg_smp — double — NOT NULL

trading_history

  • id — bigserial
  • trade_date — date — NOT NULL
  • seller — varchar(32) — NOT NULL
  • buyer — varchar(32) — NOT NULL
  • plant_id — bigint — NOT NULL
  • raw_trade_date — varchar(32) — NOT NULL

user

  • id — bigserial
  • is_superuser — boolean — NOT NULL
  • email — varchar(80) — NOT NULL
  • password — varchar(100) — NOT NULL
  • name — varchar(30) — NOT NULL
  • level — integer — NOT NULL
  • phone — varchar(30) — NOT NULL
  • first_file — varchar(200)
  • second_file — varchar(200)
  • address — varchar(50)
  • interest — varchar(50)
  • company_name — varchar(150)
  • company_type — varchar(300)
  • receive_email — boolean — NOT NULL
  • receive_sms — boolean
  • email_cert — boolean — NOT NULL
  • open_profile — boolean
  • date_joined — timestamp
  • last_login — timestamp
  • lastlogin_ip — varchar(20)
  • denied — boolean
  • market — boolean — NOT NULL
  • sms_cert — boolean — NOT NULL
  • map_my_vpp — boolean — NOT NULL
  • country_code — varchar(2)
  • language_code — varchar(2)
  • deleted_at — timestamp
  • is_active — boolean — NOT NULL
  • is_staff — boolean — NOT NULL
  • is_admin — boolean — NOT NULL
  • receive_kakaotalk — boolean
  • nickname — varchar(30)
  • telephone — varchar(30)

user_connect_plant

  • status — varchar(1) — NOT NULL
  • plant_license_files_id — bigint — NOT NULL
  • plant_id — bigint

user_groups

  • id — bigserial
  • user_id — bigint — NOT NULL
  • group_id — integer — NOT NULL

user_has_plant_license_file

  • id — bigserial
  • image_url — varchar(200) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • user_id — bigint — NOT NULL

user_plant_like

  • id — bigserial
  • plant_id — bigint
  • user_id — bigint

user_plant_notify

  • id — bigserial
  • plant_id — bigint
  • user_id — bigint

user_user_permissions

  • id — bigserial
  • user_id — bigint — NOT NULL
  • permission_id — integer — NOT NULL

users_userloginlog

  • id — bigserial
  • created — timestamp — NOT NULL
  • modified — timestamp — NOT NULL
  • ip_address — inet — NOT NULL
  • user_agent — varchar(300)
  • user_id — bigint

verify_desired_price

  • id — bigserial
  • price — bigint — NOT NULL
  • type — varchar(16) — NOT NULL
  • status — varchar(16) — NOT NULL
  • created_datetime — timestamp — NOT NULL
  • updated_datetime — timestamp — NOT NULL
  • plant_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

verify_license

  • id — bigserial
  • status — varchar(16) — NOT NULL
  • created_datetime — timestamp — NOT NULL
  • updated_datetime — timestamp
  • verify_datetime — timestamp
  • plant_id — bigint
  • user_id — bigint — NOT NULL
  • commercial_operation_license — varchar(100)
  • plant_license — varchar(100)
  • commercial_operation_license_origin_name — varchar(64)
  • plant_license_origin_name — varchar(64)