그린나우 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