AniFarm
Tables (10)
auth
- user_id (Key) — [PK] integer — Primary key — NOT NULL
- email — character varying(100)
- password — character varying(255)
- birth_date — date
- created_at — timestamp without time zone
comments
- comment_id (Key) — [PK] integer — Primary key — NOT NULL
- user_id (key3) — [FK} integer — Foreign key — NOT NULL
- post_id (Key2) — [FK] integer — Foreign key → auth.user_id — NOT NULL
- content — text
- created_at — timestamp without time zone
- community_type — character varying
- parent_id — integer
crop_costs
- id — [PK] integer — Primary key — NOT NULL
- crop_id (key) — [FK] integer — Foreign key → crops.id — NOT NULL
- cost_type — character varying(50)
- amount — numeric(10,2)
crops
- id (key) — [PK] integer — Primary key — NOT NULL
- crop_name — character varying(50)
- revenue_per_hour — numeric(10,2)
- revenue_per_3_3m — numeric(10,2)
- annual_sales — numeric(10,2)
- total_cost — numeric(10,2)
growth_calendar
- id (key) — [PK] integer — Primary key — NOT NULL
- user_id (Key) — [FK} integer — Foreign key → auth.user_id — NOT NULL
- region — character varying(100)
- crop — character varying(100)
- growth_date — date
- created_at — timestamp without time zone
market_data
- year — bigint
- week — bigint
- 갈치 — double precision
- 감 — double precision
- 감귤 — double precision
- 건고추 — double precision
- 건멸치 — double precision
- 고구마 — double precision
- 굴 — double precision
- 김 — double precision
- 대파 — double precision
- 딸기 — double precision
- 마늘 — double precision
- 무 — double precision
- 물오징어 — double precision
- 바나나 — double precision
- 방울토마토 — double precision
- 배 — double precision
- 배추 — double precision
- 복숭아 — double precision
- 사과 — double precision
- 상추 — double precision
- 새우 — double precision
- 수박 — double precision
- 시금치 — double precision
- 쌀 — double precision
- 양파 — double precision
- 오렌지 — double precision
- 오이 — double precision
- 전복 — double precision
- 참다래 — double precision
- 참외 — double precision
- 찹쌀 — double precision
- 체리 — double precision
- 토마토 — double precision
- 포도 — double precision
price_data
- id (Key) — [PK] integer — Primary key — NOT NULL
- item_name — character varying(50)
- price — character varying(50)
- unit — character varying(20)
- date — date
- previous_change (Field) — integer
- price_change (pirce_change) — integer
- yesterday_price — integer
- category_code — character varying(10)
- category_name — character varying(50)
- has_dpr1 — boolean
- created_at — timestamp without time zone
quiz
- id (Key) — [PK] integer — Primary key — NOT NULL
- crop — character varying(50)
- question — text
- option_1 — text
- option_2 — text
- option_3 — text
- option_4 — text
- correct_answer — text
sales_data
- crop_name — text
- previous_year — bigint
- current_year — bigint
write
- post_id (key) — [PK] integer — Primary key — NOT NULL
- user_id (Key2) — [FK} integer — Foreign key → auth.user_id — NOT NULL
- title — character varying(50)
- content — character varying(700)
- date — date
- category — character varying(10)
- community_type — community_type