KHU-Farm
Tables (25)
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (seller_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (fruit_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (order_detail_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (rating) — int — NOT NULL — 별점
- Field (image) — text — 리뷰 이미지
- Field (title) — varchar(20) — NOT NULL — 제목
- Field (content) — varchar(300) — NOT NULL — 내용
- Field (created_at) — datetime — NOT NULL — 생성 일시
- Field (is_answered) — boolean — NOT NULL — 답변 여부
- Field (is_pointed) — boolean — NOT NULL — 포인트 지급 여부
Untitled (Image)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Field (image_url)
- Field (image_path)
- Field (image_status)
Untitled (fruitRegularPrice)
- Key (id) — int — Primary key — NOT NULL — Auto Increment
- Key (fruit_category_id) — int — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (price) — int — NOT NULL — 과일 정가
Untitled (payment)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (order_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (totalPrice) — int — NOT NULL — 총 결제 금액
- Field (imp_uid) — varchar(100) — NOT NULL — 결제 번호
- Field (merchant_uid) — varchar(30) — NOT NULL — 주문 번호
- Field (pay_method) — varchar(10) — NOT NULL — 결제 방식
- Field (payment_status) — enum — NOT NULL — 결제 상태
- Field (paid_at) — datetime — 결제 일시
- Field (cancelled-at) — datetime — 취소 일시
- Field (failed_at) — datetime — 실패 일시
- Field (fail_reason) — varchar(100) — 실패 이유
Untitled (refreshToken)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (token) — varchar(100) — NOT NULL — 재발급 토큰
Untitled (walking)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (steps) — int — NOT NULL — 걸음수
- Field (get_steps) — int — NOT NULL — 회득 걸음 수
Untitled (attendance)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (created_at) — datetime — NOT NULL — 출석일
Untitled (pointHistory)
- Key (id) — bigint — Primary key — NOT NULL — Auto Incremnet
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (point) — int — NOT NULL — 획득 포인트 양
- Field (created_at) — datetime — NOT NULL — 획득 날짜
- Field (type) — emun — NOT NULL — 획득 이벤트 종류
- Field (type_id) — bigint — NOT NULL — 관련 이벤트 ID
Untitled (inquiryReply)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (content) — varchar(300) — NOT NULL — 내용
- Field (created_at) — datetime — NOT NULL — 작성 일자
Untitled (reviewReply)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (content) — varchar(300) — NOT NULL — 내용
- Field (created_at) — datetime — NOT NULL — 작성 일시
Untitled (orderDetail)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (order_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (fruit_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (price) — int — NOT NULL — 가격
- Field (count) — int — NOT NULL — 개수
- Field (weight) — int — NOT NULL — 무게
- Field (is_reviewed) — boolean — NOT NULL — 리뷰 작성 여부
- Field (delivery_company) — enum — 배송사
- Field2 (delivery_number) — varchar(50) — 송장 번호
- Field3 (order_status) — enum — NOT NULL — 주문 상태
- Field (refund_reason) — varchar(100) — 환불 사유
Untitled (order)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (merchant_uid) — varchar(30) — NOT NULL — 주문 번호
- Field (ordererName) — varchar(20) — NOT NULL — 주문자 성함
- Field (totalPrice) — int — NOT NULL — 총 결제 금액
- Field (created_at) — datetime — NOT NULL — 주문일시
- Field (order_count) — int — NOT NULL — 주문상품개수
- Field (port_code) — varchar(10) — NOT NULL — 우편번호
- Field (address) — varchar(100) — NOT NULL — 주소
- Field (address_detail) — varchar(20) — NOT NULL — 상세 주소
- Field (recipient) — varchar(10) — NOT NULL — 수령인
- Field (phone_number) — varchar(15) — NOT NULL — 전화번호
- Field (order_request) — varchar(100) — NOT NULL — 배송 요청사항
- Field (representative_item) — varchar(100) — NOT NULL — 대표상품
- Field (fail_reason) — varchar(100) — 실패 이유
Untitled (inquiry)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (seller_id) — bigint — Foreign key → Untitled.Key — Auto Increment
- Key (fruit_id) — bigint — Foreign key → Untitled.Key — Auto Increment
- Field (is_private) — boolean — NOT NULL — 비밀글 여부
- Field (is_answered) — boolean — NOT NULL — 답변 여부
- Field (created_at) — datetime — NOT NULL — 작성 일자
- Field (content) — varchar(300) — NOT NULL — 내용
Untitled (user)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Field (name) — varchar(20) — NOT NULL — 이름
- Field (email) — varchar(200) — NOT NULL — 이메일
- Field (phone_num) — varchar(20) — NOT NULL — 전화번호
- Field (user_id) — varchar(20) — NOT NULL — 아이디
- Field (password) — varchar(20) — NOT NULL — 비밀번호
- Field (status) — enum — NOT NULL — 회원 탈퇴 상태
- Field (created_at) — datetime — NOT NULL — 생성 일시
- Field (updated_at) — datetime — NOT NULL — 수정 일시
- Field (version) — bigint — NOT NULL — 앱 버전
- Field (user_type) — enum — NOT NULL — 회원 유형 구분(개인, 기업,농가회원, 관리자)
- Field (total_point) — bigint — NOT NULL — 총 보유 포인트
- Field (total_donation) — bigint — NOT NULL — 총 기부 금액
- Field (total_price) — bigint — NOT NULL — 총 구매 가격
- Field (total_weight) — bigint — NOT NULL — 총 구매 무게
- Field (discounted_price) — bigint — NOT NULL — 타 과일 대비 저렴하게 구매한 금액
Untitled (wishList)
- Key (id) — bigint — Primary key — NOT NULL — AutoIncrement
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (fruit_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
Untitled (cart)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (fruit_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (count) — int — NOT NULL — 개수
Untitled (address)
- Key (id) — bigint — Primary key — NOT NULL — Auto Incremnet
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (address_name) — varchar(20) — NOT NULL — 배송지 이름
- Field (port_code) — varchar(10) — NOT NULL — 우편번호
- Field (address) — varchar(100) — NOT NULL — 주소
- Field (detail_address) — varchar(20) — NOT NULL — 상세 주소
- Field (is_default) — boolean — NOT NULL — 기본 배송지 여부
- Field (recipient) — varchar(10) — NOT NULL — 수령인
- Field (phoneNumber) — varchar(15) — NOT NULL — 전화번호
- Field (created_at) — datetime — NOT NULL — 생성 일시
- Field (updated_at) — datetime — NOT NULL — 수정 일시
Untitled (wholesaleRetailCategory)
- Key (id) — int — Primary key — NOT NULL — Auto Increment
- Field (name) — varchar(10) — NOT NULL — 도매/소매
Untitled (fruitCategory)
- Key (id) — int — Primary key — NOT NULL — Auto Increment
- Field (name) — varchar(10) — NOT NULL — 과일 이름
Untitled (seller)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (brand) — varchar(20) — NOT NULL — 농가명
- Field (title) — varchar(20) — NOT NULL — 메인 문구
- Field (description) — varchar(30) — NOT NULL — 설명 문구
- Field (image) — text — NOT NULL — 사진
Untitled (fruit)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (seller_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (fruit_category_id) — int — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (wholesale_retail_category_id) — int — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (title) — varchar(100) — NOT NULL — 제목
- Field (image) — text — NOT NULL — 사진
- Field (price) — int — NOT NULL — 가격
- Field (weight) — int — NOT NULL — 과일 무게
- Field (delivery_company) — enum — NOT NULL — 배송사
- Field (delivery_day) — int — NOT NULL — 최대 배송 준비기간
- Field (created_at) — datetime — NOT NULL — 생성일
- Field (updated_at) — datetime — NOT NULL — 수정일
- Field (rating_sum) — int — NOT NULL — 별접 합
- Field (rating_cnt) — int — NOT NULL — 별점 개수
- Field (description) — varchar(500) — NOT NULL — 내용
- Field (fruit_status) — enum — NOT NULL — 등록 상태
- Field (stock) — int — NOT NULL — 수량
Untitled (businessInfo)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (business_id) — varchar(20) — NOT NULL — 사업자 등록번호
- Field (business_name) — varchar(20) — NOT NULL — 대표자 성명
- Field (open_date) — datetime — NOT NULL — 개업일자
Untitled (notification)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Field (title) — varchar(100) — NOT NULL — 알림 제목
- Field (content) — varchar(300) — NOT NULL — 알림 내용
- Field (is_read) — boolean — NOT NULL — 읽음 여부
- Field (created_at) — datetime — NOT NULL — 생성일시
Untitled (agreement)
- Key (id) — bigint — Primary key — NOT NULL — Auto Increment
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — Auto Increment
- Key (terms_conditions_id) — int — Foreign key → Untitled.Key — NOT NULL — 약관코드
- Field (agreement) — boolean — NOT NULL — 동의여부
- Field (agree_at) — datetime — NOT NULL — 동의일자
Untitled (termsConditions)
- Key (id) — int — Primary key — NOT NULL — 약관코드
- Field (name) — varchar(20) — NOT NULL — 약관명
- Field (content) — varchar(1000) — NOT NULL — 약관내용
- Field (essential) — enum — NOT NULL — 필수여부