copy

Tables (21)

Category

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • title — varchar(255) — NOT NULL

Chat

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • live_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • content — varchar(3000)

Coupon

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • coupon_name — varchar(255) — NOT NULL
  • discount_percentage — int — NOT NULL
  • coupon_type — varchar(255) — NOT NULL
  • expiration — timestamp — NOT NULL
  • farm_id — bigint — NOT NULL

Delivery

  • id — bigint — Primary key — NOT NULL
  • ordering_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • courier — varchar(255)
  • billing_number — varchar(255)
  • delivery_at — timestamp — NOT NULL
  • delivery_status — ENUM — NOT NULL

Farm

  • id — bigint — Primary key — NOT NULL
  • seller_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • farm_name — varchar(255) — NOT NULL — UNIQUE
  • banner_image_url — varchar(32779) — NOT NULL
  • profile_image_url — varchar(32779) — NOT NULL
  • fram_intro — varchar(5000) — NOT NULL
  • orderCount — bigint — NOT NULL
  • favoriteCount — bigint — NOT NULL

FarmCategoryRelation

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — NOT NULL
  • farm_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL

FarmNotice

  • id — bigint — Primary key — NOT NULL
  • farm_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — varchar(3000) — NOT NULL

FarmNoticeImage

  • id — bigint — Primary key — NOT NULL
  • notice_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • image_url — varchar(32779) — NOT NULL

Favorites

  • id — bigint — Primary key — NOT NULL
  • farm_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL

Live

  • id — bigint — Primary key — NOT NULL
  • farm_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • end_at — timestamp
  • title — varchar(255) — NOT NULL
  • live_image — varchar(500)

Member

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • address — varchar(255)
  • address_detail — varchar(255)
  • zipcode — VARCHAR(255)
  • fcmToken — varchar(255)
  • billing_key — varchar(255)

MemberCouponRelation

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • coupon_id — bigint — NOT NULL
  • ordering_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • used_at — timestamp — NOT NULL
  • issued_at — timestamp — NOT NULL

NoticeComment

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • contents — varchar(300) — NOT NULL
  • notice_id — bigint — NOT NULL

Ordering

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • package_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • total_price — bigint — NOT NULL
  • discount_price — int — NOT NULL
  • farm_id — bigint — NOT NULL

PackageProduct

  • id — bigint — Primary key — NOT NULL
  • farm_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • pakage_name — varchar(255) — NOT NULL
  • delivery_cycle — int — NOT NULL
  • price — bigint — NOT NULL

PackageProductImage

  • id — bigint — Primary key — NOT NULL
  • package_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • image_url — varchar(32779) — NOT NULL

Receipt

  • id — bigint — Primary key — NOT NULL
  • ordering_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • payed_at — timestamp — NOT NULL
  • before_price — bigint — NOT NULL
  • discount_price — int — NOT NULL
  • total_price — bigint
  • payment_method — varchar(255)

Review

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • package_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • title — varchar(50) — NOT NULL
  • rating — int — NOT NULL
  • contents — varchar(255)

ReviewImage

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • image_url — varchar(255) — NOT NULL

Seller

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • business_number — varchar(255) — NOT NULL
  • business_name — varchar(255) — NOT NULL

Subscription

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • package_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • del_yn — varchar(1) — NOT NULL
  • canceled_at — timestamp
  • payDate — datetime