test

Tables (13)

article

  • article_id — bigint
  • title — varchar(30) — NOT NULL
  • display_image — int
  • kind — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • target — varchar(10) — NOT NULL
  • created_at — timestamp

article_image_mapping

  • id — bigserial
  • article_id — bigint
  • file_id — int

business_license

  • license_id — int
  • company_name — varchar(30) — NOT NULL
  • representative — varchar(10) — NOT NULL
  • company_address — varchar(255) — NOT NULL
  • company_address_detail — varchar(50)

expert

  • expert_id — serial
  • user_id — INT — NOT NULL
  • complete_request — INT
  • introduction — varchar(255)
  • license_id — INT
  • created_at — timestamp
  • deleted_at — timestamp

expert_career

  • career_id — bigserial
  • expert_id — int — NOT NULL
  • title — varchar(255)
  • from_date — timestamp — NOT NULL
  • to_date — timestamp
  • description — varchar(255)

expert_review

  • review_id — bigserial
  • expert_id — INT — NOT NULL
  • score — INT — NOT NULL
  • content — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

file

  • file_id — SERIAL
  • path — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(15) — NOT NULL
  • size — INT

insect_control_received_bid

  • bid_id — bigserial
  • insect_request_id — INT — NOT NULL
  • expert_id — int — NOT NULL
  • bid_price — BIGINT — NOT NULL
  • bid_description — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

insect_control_request

  • insect_request_id — serial
  • user_id — INT — NOT NULL
  • land_id — INT — NOT NULL
  • status — varchar(16)
  • request_date — timestamp — NOT NULL
  • request_description — varchar(255)
  • pesticide — varchar(255)
  • created_at — timestamp
  • deleted_at — timestamp
  • updated_at — timestamp

land

  • land_id — SERIAL
  • user_id — INT
  • land_address — varchar(255)
  • land_address_detail — varchar(50)
  • land_size — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

message

  • message_id — BIGSERIAL
  • message_group_id — INT — NOT NULL
  • message_from — INT — NOT NULL
  • message_to — INT — NOT NULL
  • is_pinned — BOOLEAN
  • reply_message_id — BIGINT
  • content — TEXT
  • file_id — INT
  • land_id — INT
  • created_at — TIMESTAMP

message_group

  • message_group_id — SERIAL
  • user_id — INT
  • expert_id — INT
  • service_request_id — INT — NOT NULL
  • service_type — varchar(10) — NOT NULL
  • last_connection_time — TIMESTAMP
  • created_at — TIMESTAMP

users

  • user_id — SERIAL
  • phone_number — VARCHAR(15) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • provider — VARCHAR(255)
  • oauth_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(10)
  • profile_image — text
  • nickname — VARCHAR(10)
  • zone_code — VARCHAR(10)
  • address — VARCHAR(255)
  • address_detail — VARCHAR(50)
  • refresh_token — TEXT
  • notification_enabled — BOOLEAN
  • marketing_enabled — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP