dddddd

Tables (8)

boards

  • board_num — int — Primary key — NOT NULL
  • board_title — varchar(255) — NOT NULL
  • board_contents — text — NOT NULL
  • reg_date — datetime — NOT NULL
  • update_date — datetime — NOT NULL — 게시글을 수정하고나면 수정한 날짜,시간으로 업데이트(수정된 게시글을 보여주기위함)
  • read_count — int — NOT NULL
  • user_id — varchar(300) — NOT NULL — 작성자를 저장하기위함
  • replt_count — int
  • category — varchar(300) — NOT NULL
  • topic — varchar(300)

business_info

  • business_info_idx — int — Primary key — NOT NULL
  • visit_count — INT
  • use_time — VARCHAR(100)
  • content — TEXT
  • overall_grade — DECIMAL(3, 2)
  • grade_count — int
  • amenities — text
  • buseiness_id — varchar(300) — NOT NULL

business_users

  • business_idx — int — Primary key — NOT NULL
  • business_id — varchar(300) — NOT NULL
  • business_password — VARCHAR(100) — NOT NULL
  • business_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • business_zip_code — VARCHAR(20) — NOT NULL
  • business_address — VARCHAR(255) — NOT NULL
  • business_address_detail — VARCHAR(255) — NOT NULL
  • business_additional_info — VARCHAR(100) — 무슨 동인지 알려주는 컬럼
  • business_phone_number — VARCHAR(20) — NOT NULL
  • business_email — VARCHAR(100) — NOT NULL
  • business_category — VARCHAR(100) — NOT NULL
  • business_store_name — varchar(200) — NOT NULL

kakao_users

  • kakao_idx — VARCHAR(100) — Primary key — NOT NULL
  • kakao_name — VARCHAR(100) — NOT NULL

replies

  • reply_num — int — Primary key — NOT NULL
  • board_num — int — NOT NULL
  • user_id — varchar(300) — NOT NULL
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)

schedule

  • schedule_num — int — Primary key — NOT NULL
  • schedule_date — varchar(500) — NOT NULL
  • store_name — varchar(300) — NOT NULL
  • addr — text — NOT NULL
  • memo — text
  • coords — text — NOT NULL
  • user_id — varchar(300) — NOT NULL

user_requests

  • request_num — int — Primary key — NOT NULL
  • category — varchar(300) — NOT NULL
  • address — varchar(300) — NOT NULL
  • request_type — varchar(100) — NOT NULL
  • reg_date — varchar(300) — NOT NULL
  • personnel — int
  • fuel — varchar(20)
  • cost — varchar(200)
  • amenities — text
  • memo — text — NOT NULL
  • user_id — varchar(300) — NOT NULL — 요청서를 작성한 사람의 아이디 저장
  • business_id — varchar(300) — 제안서를 구분 하기위해서

users

  • user_idx — int — Primary key — NOT NULL
  • user_id — varchar(300) — NOT NULL
  • user_password — VARCHAR(100) — NOT NULL
  • user_name — varchar(300) — NOT NULL
  • user_phone_number — VARCHAR(20)
  • user_email — VARCHAR(100) — NOT NULL
  • zip_code — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(255)
  • additional_info — VARCHAR(100) — 무슨 동인지 알려주는 컬럼
  • user_gender — ENUM('M', 'W') — NOT NULL