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