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 — 필수여부