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