그린나우 ERD
테이블 (22)
article
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- article_type — varchar(127)
- content — text
- height — varchar(127)
- like_count — int — NOT NULL
- round — varchar(127)
- status — varchar(127)
- title — varchar(255)
- tree_count — int — NOT NULL
- tree_detail_type — varchar(255)
- tree_type — varchar(127)
- view — int — NOT NULL
- width — varchar(127)
- tree_id — bigint — 외래 키 → tree.id
- user_id — bigint — 외래 키 → users.id
- deleted_date — datetime(6)
- valid — bit(1) — NOT NULL
- area — varchar(127)
- branch — varchar(127)
auth_number
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- auth_key — varchar(255)
- auth_status — varchar(127)
- auth_type — varchar(127)
- complete_time — datetime(6)
- number — int — NOT NULL
black_list
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- blocked_user_id — bigint — NOT NULL
- user_id — bigint — 외래 키 → users.id
city
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255)
- state_name — varchar(255)
- state_id — bigint — 외래 키 → state.id
comment
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- content — varchar(1000)
- like_count — int — NOT NULL
- article_id — bigint — 외래 키 → article.id
- parent_comment_id — bigint — 외래 키 → comment.id
- sales_post_id — bigint — 외래 키 → sales_post.id
- user_id — bigint — 외래 키 → users.id
- deleted_date — datetime(6)
- valid — bit(1) — NOT NULL
comment_love
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- comment_id — bigint — 외래 키 → comment.id
- user_id — bigint — 외래 키 → users.id
- article_id — bigint — 외래 키 → article.id
- sales_post_id — bigint — 외래 키 → sales_post.id
contract
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- signing_status — varchar(255)
- buyer_id — bigint — 외래 키 → users.id
- seller_id — bigint — 외래 키 → users.id
- balance — bigint — NOT NULL
- balance_payment_date — varchar(255)
- down_payment — bigint — NOT NULL
- down_payment_date — date
- tree_sales_contract_date — date
- estimate_id — bigint — 외래 키 → estimate.id
- special_note — varchar(255)
- template_id — varchar(255)
- complete_time — datetime(6)
- e_doc_id — bigint
- tax_invoice_id — bigint
- contract_files3 — varchar(255)
estimate
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- company_name — varchar(255)
- detailed_address — varchar(255)
- address — varchar(255)
- representative — varchar(255)
- special_note — varchar(255)
- total_price — bigint — NOT NULL
- valid — bit(1) — NOT NULL
- quote_request_id — bigint — 외래 키 → quote_request.id
- seller_id — bigint — 외래 키 → users.id
- quote_day — datetime(6)
- evaluated — bit(1) — NOT NULL
- business_number — varchar(255)
- manager — varchar(255)
- manager_email — varchar(255)
- phone — varchar(255)
estimate_letter
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- status — varchar(255)
- quote_request_id — bigint — 외래 키 → estimate.id
- receiver_user_id — bigint — 외래 키 → users.id
- sender_user_id — bigint — 외래 키 → users.id
- estimate_id — bigint — 외래 키 → estimate.id
estimate_tree
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- price — bigint — NOT NULL
- estimate_id — bigint — 외래 키 → estimate.id
- quote_request_id — bigint — 외래 키 → quote_request_tree.id — NOT NULL
quote_request
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- address — varchar(255)
- company_name — varchar(255) — NOT NULL
- customer_name — varchar(255) — NOT NULL
- detailed_address — varchar(255)
- quote_date — date — NOT NULL
- quote_title — varchar(255) — NOT NULL
- special_notes — varchar(255)
- user_id — bigint — 외래 키 → users.id
- valid — bit(1) — NOT NULL
- business_number — varchar(255)
- manager — varchar(255)
- manager_email — varchar(255)
- phone — varchar(255)
quote_request_letter
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- status — varchar(255)
- quote_request_id — bigint — 외래 키 → quote_request.id
- receiver_user_id — bigint — 외래 키 → users.id
- sender_user_id — bigint — 외래 키 → users.id
quote_request_tree
- id — bigint — 기본 키 — NOT NULL
- area — varchar(128)
- height — varchar(128)
- price — bigint — NOT NULL
- round — varchar(128)
- tree_count — int — NOT NULL
- tree_type — varchar(255)
- width — varchar(128)
- quote_request_id — bigint — 외래 키 → quote_request.id — NOT NULL
- tree_id — bigint — 외래 키 → tree.id — NOT NULL
- branch — varchar(128)
- standard — varchar(128)
sales_post
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- content — text
- height — varchar(127)
- like_count — int — NOT NULL
- price — int — NOT NULL
- round — varchar(127)
- sales_post_type — varchar(127)
- status — varchar(127)
- title — varchar(255)
- tree_count — int — NOT NULL
- tree_detail_type — varchar(255)
- tree_type — varchar(127)
- view — int — NOT NULL
- width — varchar(127)
- city_id — bigint — 외래 키 → city.id
- tree_id — bigint — 외래 키 → tree.id
- user_id — bigint — 외래 키 → users.id
- deleted_time — datetime(6)
- valid — bit(1) — NOT NULL
- area — varchar(255)
- branch — varchar(127)
- address — varchar(255)
- detailed_address — varchar(255)
seller_info
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- account_number — varchar(255)
- bank_type — varchar(255)
- business_image — varchar(255)
- business_images3name — varchar(255)
- business_number — varchar(255)
- user_id — bigint — 외래 키 → users.id
- account_holder — varchar(255)
state
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255)
tree
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255)
- tree_type — varchar(255)
- visible — bit(1) — NOT NULL
user_role
- user_id — bigint — 외래 키 → users.id — NOT NULL
- roles — varchar(255)
users
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- farm_name — varchar(255)
- file_origin_name — varchar(255)
- files3name — varchar(255)
- marketing_agree — bit(1) — NOT NULL
- nickname — varchar(255)
- password — varchar(255) — NOT NULL
- phone — varchar(255)
- platform_id — varchar(255)
- city_id — bigint — 외래 키 → city.id
- name — varchar(255)
- personal_information_consent — bit(1) — NOT NULL
- service_terms_agreement — bit(1) — NOT NULL
- over14agreement — bit(1) — NOT NULL
- valid — bit(1) — NOT NULL
- mode — varchar(255)
- address — varchar(255)
- detailed_address — varchar(255)
- intro — varchar(500)
- withdraw_day — datetime(6)
- withdraw_reason — varchar(500)
- withdraw_agree — bit(1) — NOT NULL
- phone_validate — bit(1) — NOT NULL
wish_seller
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- company_name — varchar(255)
- email — varchar(255)
- manager — varchar(255)
- phone — varchar(255)
- quote_request_id — bigint — 외래 키 → quote_request.id
writing_file
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- file_origin_name — varchar(255)
- files3name — varchar(255)
- article_id — bigint — 외래 키 → article.id
- salespost_id — bigint — 외래 키 → sales_post.id
writing_love
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- article_id — bigint — 외래 키 → article.id
- sales_post_id — bigint — 외래 키 → sales_post.id
- user_id — bigint — 외래 키 → users.id