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)