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