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