test

Tables (28)

addresses

  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • title — VARCHAR(30)
  • city — VARCHAR(100) — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • neighborhood — VARCHAR(100) — NOT NULL
  • street_address — VARCHAR(200) — NOT NULL
  • postal_code — VARCHAR(20)
  • detail_address — VARCHAR(200)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

admins

  • id — VARCHAR(36)
  • role — ENUM('ROLE_ADMIN')
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

buyers

  • user_id — VARCHAR(36)
  • name_masking_status — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

chat_messages

  • id — VARCHAR(36)
  • room_id — VARCHAR(36) — NOT NULL
  • sender_id — VARCHAR(36) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • sent_at — DATETIME
  • read_at — DATETIME
  • INDEX — idx_chat_messages_room_id
  • INDEX — idx_chat_messages_sender_id

chat_rooms

  • id — VARCHAR(36)
  • buyer_id — VARCHAR(36) — NOT NULL
  • seller_id — VARCHAR(36) — NOT NULL
  • created_at — DATETIME

coupons

  • id — VARCHAR(36)
  • code — VARCHAR(50) — NOT NULL
  • discount_type — ENUM('PERCENT', 'AMOUNT') — NOT NULL
  • discount_value — INT — NOT NULL
  • expires_at — DATETIME
  • usage_limit — INT
  • used_count — INT

faqs

  • faq_id — VARCHAR(36)
  • question — VARCHAR(255) — NOT NULL
  • answer — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

images

  • id — VARCHAR(36)
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

inquiries

  • inquiry_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • parent_id — VARCHAR(36)
  • admin_id — VARCHAR(36)
  • title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • status — ENUM('pending', 'answered') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

notices

  • notice_id — VARCHAR(36)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

notifications

  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • type — ENUM( 'ORDER_STATUS_CHANGED', 'DELIVERY_STARTED', 'COUPON_ISSUED', 'REVIEW_REQUEST', 'SYSTEM_ALERT', 'REFUND_COMPLETED', 'CHATTING' ) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — DATETIME
  • read_at — DATETIME

order_issue_items

  • id — VARCHAR(36)
  • seller_id — VARCHAR(36) — NOT NULL
  • order_issue_id — VARCHAR(36) — NOT NULL
  • order_item_id — VARCHAR(36) — NOT NULL
  • quantity — INT — NOT NULL
  • item_price — BIGINT — NOT NULL
  • status — ENUM('REQUESTED', 'APPROVED', 'COMPLETED', 'REJECTED')
  • issue_reason — TEXT
  • refund_method — VARCHAR(50)
  • refund_amount — BIGINT
  • delivery_fee — BIGINT
  • return_fee — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

order_issues

  • id — VARCHAR(36)
  • order_id — BIGINT — NOT NULL
  • issue_type — ENUM('CANCEL', 'RETURN', 'EXCHANGE', 'REFUND') — NOT NULL
  • issue_status — ENUM('REQUESTED', 'APPROVED', 'COMPLETED', 'REJECTED')
  • issue_request_date — DATETIME — NOT NULL
  • issue_complete_date — DATETIME
  • item_price — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

order_items

  • id — VARCHAR(36)
  • order_id — BIGINT — NOT NULL
  • product_id — VARCHAR(36) — NOT NULL
  • quantity — INT — NOT NULL
  • price — BIGINT — NOT NULL

orders

  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • order_status — ENUM( 'PAYMENT_PENDING', 'PAYMENT_COMPLETED', 'PREPARING', 'READY_FOR_SHIPMENT', 'IN_DELIVERY', 'DELIVERED' )
  • total_price — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

payments

  • id — VARCHAR(36)
  • order_id — BIGINT — NOT NULL
  • method — ENUM('TOSS') — NOT NULL
  • status — ENUM('PENDING', 'SUCCESS', 'FAILED')
  • paid_at — DATETIME

pets

  • id — VARCHAR(36)
  • buyer_id — VARCHAR(36) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • species — VARCHAR(50)
  • breed — VARCHAR(100)
  • age — TINYINT
  • gender — ENUM('M','F')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

products

  • id — VARCHAR(36)
  • product_number — BIGINT — NOT NULL
  • seller_id — VARCHAR(36) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • contents — TEXT — NOT NULL
  • category — ENUM('dog', 'cat')
  • stock_status — ENUM('IN_STOCK', 'OUT_OF_STOCK')
  • price — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

products_images

  • id — VARCHAR(36)
  • product_id — VARCHAR(36) — NOT NULL
  • product_image_id — VARCHAR(36) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

refunds

  • id — VARCHAR(36)
  • payment_id — VARCHAR(36) — NOT NULL
  • reason — TEXT
  • refunded_at — DATETIME

reports

  • report_id — VARCHAR(36)
  • report_type — ENUM('product', 'review') — NOT NULL
  • target_id — VARCHAR(36) — NOT NULL
  • reporter_id — VARCHAR(36) — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • status — ENUM('pending', 'completed') — NOT NULL
  • created_at — TIMESTAMP
  • processed_at — TIMESTAMP

reviews

  • id — VARCHAR(36)
  • product_id — VARCHAR(36) — NOT NULL
  • buyer_id — VARCHAR(36) — NOT NULL
  • star — DECIMAL(2,1) — NOT NULL
  • contents — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

reviews_images

  • review_id — VARCHAR(36) — Primary key — NOT NULL
  • review_image_id — VARCHAR(36) — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

sellers

  • user_id — VARCHAR(36)
  • vendor_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • settlement_bank — VARCHAR(50)
  • settlement_acc — VARCHAR(30)
  • created_at — DATETIME
  • updated_at — DATETIME

settlements

  • id — VARCHAR(36)
  • seller_id — VARCHAR(36) — NOT NULL
  • order_item_id — VARCHAR(36) — NOT NULL
  • item_price — BIGINT — NOT NULL
  • commission_rate — DECIMAL(5,2) — NOT NULL
  • commission_amount — BIGINT — NOT NULL
  • settlement_amount — BIGINT — NOT NULL
  • settlement_status — ENUM('PENDING', 'SETTLED', 'CANCELLED')
  • settled_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

shipments

  • id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • seller_id — VARCHAR(36) — NOT NULL
  • courier — VARCHAR(50) — NOT NULL
  • tracking_number — VARCHAR(100) — NOT NULL
  • shipped_at — DATETIME
  • delivered_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

user_coupons

  • user_coupon_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • coupon_id — BIGINT — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • used_at — TIMESTAMP

users

  • id — VARCHAR(36)
  • provider — VARCHAR(10) — NOT NULL
  • provider_id — VARCHAR(100) — NOT NULL
  • user_name_attribute — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('ROLE_TEMP', 'ROLE_BUYERS', 'ROLE_SELLERS')
  • profile_image_url — VARCHAR(255) — NOT NULL
  • account_disable — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME