farm

Tables (3)

calculate_history (Untitled)

  • calculate_history_id (Key) — BIGINT — Primary key — NOT NULL
  • earning_per_machine (Field) — INT
  • increase_by_labor (Field2) — INT
  • labor_cost (Field3) — INT
  • mineral_purchase_price (Field4) — INT
  • product_selling_price (Field5) — INT
  • total_earning (Field6) — INT
  • total_machine (Field7) — INT
  • created_date_time (Field8) — datetime
  • modified_date_time (Field9) — datetime

contact_message (Untitled2)

  • contact_message_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → member.user_id — NOT NULL
  • content (Field) — varchar(500)
  • user_name (Field2) — varchar(50)
  • created_date_time (Field3) — datetime
  • modified_date_time (Field4) — datetime

member (Untitled3)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — varchar(255)
  • kakao_id (Field2) — BIGINT
  • username (Field3) — varchar(255)
  • last_access_date (Field4) — varchar(255)
  • created_date_time (Field5) — datetime
  • modified_date_time (Field6) — datetime