AniFarm1

Tables (5)

auth

  • user_id — integer — NOT NULL
  • email — character — NOT NULL
  • password — character — NOT NULL
  • birth_date — date
  • created_at — timestamp

comments

  • comment_id — integer — NOT NULL
  • post_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp

sales_data_2024

  • week — character
  • persimmon — numeric
  • mandarin — numeric
  • dried_pepper — numeric
  • dried_anchovy — numeric
  • sweet_potato — numeric
  • oyster — numeric
  • seaweed — numeric
  • green_onion — numeric
  • strawberry — numeric
  • garlic — numeric
  • radish — numeric
  • squid — numeric
  • banana — numeric
  • cherry_tomato — numeric
  • pear — numeric
  • cabbage — numeric
  • peach — numeric
  • apple — numeric
  • lettuce — numeric
  • shrimp — numeric
  • watermelon — numeric
  • spinach — numeric
  • rice — numeric
  • onion — numeric
  • orange — numeric
  • cucumber — numeric
  • abalone — numeric
  • kiwi — numeric
  • oriental_melon — numeric
  • glutinous_rice — numeric
  • cherry — numeric
  • tomato — numeric
  • grape — numeric

top_10_sales

  • category — character
  • previous_year — numeric
  • base_date — numeric

write

  • post_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • title — character — NOT NULL
  • name — character
  • content — character
  • date — date
  • category — character
  • community_type — public.community_type