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