test
Tables (50)
cart_items
- id — VARCHAR(255) — Primary key — NOT NULL
- cart_id — INT — NOT NULL
- product_id — INT — NOT NULL
- product_variants_id — INT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
- discount_rate — DECIMAL(10,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- discount_price — DECIMAL(10,2)
carts
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- delivery_type — ENUM — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
categories
- id — INT — Primary key — NOT NULL
- parent_id — INT
- name — VARCHAR(50) — NOT NULL
- level — INT — NOT NULL
chat_room_members
- id — INT — Primary key — NOT NULL
- room_id — INT — NOT NULL
- user_id — INT — NOT NULL
- joined_at — DATETIME — NOT NULL
- is_active — BOOLEAN
- last_read_message_id — INT — mvp 단계 X
chat_rooms
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- type — ENUM — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
comment_likes
- id — INT — Primary key — NOT NULL
- comment_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP
contents
- id — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
coupon
- id — INT — Primary key — NOT NULL
- store_id — VARCHAR(255)
- provider_type — ENUM — NOT NULL
- name — VARCHAR(50) — NOT NULL
- discount_type — ENUM — NOT NULL
- discount_value — INT — NOT NULL
- min_order_price — INT — NOT NULL
- valid_type — ENUM — NOT NULL — days-valid_days / date - valid_until
- valid_days — INT
- valid_until — DATETIME
- created_at — TIMESTAMP — NOT NULL
- closed_at — TIMESTAMP
event
- Key — VARCHAR(255) — Primary key — NOT NULL
location
- id — INT — Primary key — NOT NULL
- region_id — INT — NOT NULL
- user_id — INT — NOT NULL
- latitude — DECIMAL(9,6)
- longitude — DECIMAL(9,6)
- address — VARCHAR(255) — NOT NULL
messages
- id — INT — Primary key — NOT NULL
- room_id — INT — NOT NULL
- sender_type — ENUM
- sender_id — INT — sender_type에 따라 user_id 또는 store_id를 넣음
- is_announcement — BOOLEAN — NOT NULL
- content — TEXT — NOT NULL
- message_type — ENUM — NOT NULL
- media_url — VARCHAR(500)
- created_at — DATETIME
option_values
- id — INT — Primary key — NOT NULL
- product_option_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL — 빨강, L, 딸기맛
- price_modifier — DECIMAL(10, 2) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
order_coupon
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- cupon_id — INT — NOT NULL
- user_cuppon_id — INT — NOT NULL
- discount_amount — DECIMAL(10,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
order_items
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- product_variants — INT — NOT NULL
- store_id — INT — NOT NULL
- store_name — TIMESTAMP
- product_name — TIMESTAMP
- price — DECIMAL(10, 2) — NOT NULL — 상품의 할인율은 적용된 상태
- quantity — INT — NOT NULL
- pickup_status — ENUM
- carrier — VARCHAR(50)
- tracking_number — VARCHAR(50)
- received_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- customer_pickup_time — TIMESTAMP
orders
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- shipping_address_id — INT — NOT NULL
- order_number — VARCHAR(50) — NOT NULL
- subtotal — DECIMAL(10, 2) — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
- status — ENUM — NOT NULL — 'shipped'- 출고, 'delivered'-수령완료
- delivery_request — VARCHAR(50)
- order_phone — VARCHAR(20) — NOT NULL
- delivery_type — ENUM — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- cart_item_ids — JSON — 장바구니로부터 주문하는 경우 삽입
owners_users
- owners_user_id — INT — Primary key — NOT NULL
- name — VARCHAR(10) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- hashed_password — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email_auth_status — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
pm_info
- id — INT — Primary key — NOT NULL
- latitude — DECIMAL(9,6) — NOT NULL
- longitude — DECIMAL(9,6) — NOT NULL
- station_name — VARCHAR(50) — NOT NULL
- station_sido — VARCHAR(50) — NOT NULL
- addr — VARCHAR(100) — NOT NULL
- pm10_grade — INT
- pm25_grade — INT
- pm10_value — INT
- pm25_value — INT
- data_time — DATETIME
- updated_at — DATETIME
post_content_blocks
- block_id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- block_type — ENUM — NOT NULL
- content — TEXT — block_type='text'일 경우
- file_url — VARCHAR(500) — block_type='image' or 'video' 일 경우
- order — INT
- created_at — TIMESTAMP
post_likes
- id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP
post_subscriptions
- id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP
post_views
- id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- viewed_at — TIMESTAMP
product_detail_images
- id — INT — Primary key — NOT NULL
- product_detail_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
product_details
- product_detail_id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- manufacturer — VARCHAR(50)
- origin_country — VARCHAR(50)
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- manufacture_date — DATE
- expiration_date — DATE
product_images
- id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL — current_timestamp
- type — ENUM — NOT NULL
product_options
- id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL — 색상, 사이즈, 맛
- type — ENUM — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
product_tags
- id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- tag_info_id — INT — NOT NULL
- type — ENUM — NOT NULL
product_variants
- id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- combination_name — VARCHAR(255) — NOT NULL — (빨강-L, 딸기맛-대용량)
- price_adjustment — DECIMAL(10, 2) — (+3000, -500)
- stock_quantity — INT — NOT NULL
- reserved_stock — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- option_combination — JSON — NOT NULL — {"색상": "빨강", "사이즈": "L"}
products
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- category_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- delivery_method — ENUM — NOT NULL
- sale_type — ENUM — NOT NULL
- cost_price — DECIMAL(10, 2) — NOT NULL
- discount_rate — DECIMAL(10, 2)
- status — ENUM — NOT NULL
- pickup_start_date — DATE
- pickup_end_date — DATE
- pickup_start_time — TIME
- pickup_end_time — TIME
- delivery_duration_days — INT — 주문 후 배송 가능까지 예상 일수
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
promotion
- id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- discount_rate — DECIMAL(10,2)
- stock_arrival_at — TIMESTAMP
- total_quantity — INT
- current_participants — INT
- current_total_quantity — INT
- status — ENUM
- type — ENUM
- start_at — DATETIME
- end_at — DATETIME
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
promotion_price_tier
- id — VARCHAR(255) — Primary key — NOT NULL
- groupbuy_id — VARCHAR(255) — NOT NULL
- min_quantity — VARCHAR(255) — NOT NULL
- price — VARCHAR(255) — NOT NULL
refresh_token
- id — INT — Primary key — NOT NULL
- user_device_id — INT — NOT NULL
- token — VARCHAR(512) — NOT NULL
- revoked — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
refund_items
- id — INT — Primary key — NOT NULL
- refund_id — INT — NOT NULL
- order_item_id — INT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
refunds
- id — INT — Primary key — NOT NULL
- payment_id — INT — NOT NULL
- pg_refund_id — VARCHAR(255)
- refund_amount — DECIMAL(10, 2) — NOT NULL
- net_refund_amount — DECIMAL(10, 2) — NOT NULL
- reason_code — VARCHAR(255)
- reason — VARCHAR(255)
- status — requested
- failed — NOT — NOT NULL
- refund_receive_account — JSON
- requested_at — TIMESTAMP
- tax_free_amount — DECIMAL(10, 2) — 토스 필수
- refund_fee — DECIMAL(10, 2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
regions
- id — INT — Primary key — NOT NULL
- pm_id — INT — NOT NULL
- weather_grid_id — INT — NOT NULL
- latitude — DECIMAL(9,6)
- longitude — DECIMAL(9,6)
- sido — VARCHAR(50) — NOT NULL
- sigungu — VARCHAR(50) — NOT NULL
- eupmyeondong — VARCHAR(50) — NOT NULL
shipping_address
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- base_address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255) — NOT NULL
- level1 — VARCHAR(255) — NOT NULL
- level2 — VARCHAR(255) — NOT NULL
- level3 — VARCHAR(255) — NOT NULL
- postcode — VARCHAR(50) — NOT NULL
- is_default_shipping — BOOLEAN — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- receiver — VARCHAR(10) — NOT NULL
social_account
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- social_id — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(512)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
store
- id — INT — Primary key — NOT NULL
- category_id — INT — NOT NULL
- owners_user_id — INT — NOT NULL
- Field — VARCHAR(20) — NOT NULL
- owner_name — VARCHAR(10) — NOT NULL
- is_locked — BOOLEAN — 비밀 상점일 경우
- access_code — VARCHAR(10) — 비밀 상점일 경우
- base_address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(9, 6)
- longitude — DECIMAL(9, 6)
- open_time — TIME
- close_time — TIME
- day_off — VARCHAR(50) — 'sun', 'mo
- manual_status — ENUM('open', 'closed', 'break', 'holiday') — (추후) 수동 설정용 영업 상태 필드
- manual_status_expire_at — TIMESTAMP — (추후) 수동 설정용 영업 상태 만료 기간 필드
- break_start_time — TIME
- break_end_time — TIME
- description — TEXT
- parking_status — ENUM('unknown', 'available', 'not_available')
- group_seat_status — ENUM('unknown', 'available', 'not_available')
- account_number — VARCHAR(50) — 무통장 입금 시 필요
- etc — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- temp_delivery_fee — DECIMAL(10, 2)
- is_local_specialty — BOOLEAN — NOT NULL — 지역 관리자가 부여하는 플래그
- name — VARCHAR(50) — NOT NULL
store_categories
- id — INT — Primary key — NOT NULL
- parent_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- level — INT — NOT NULL
store_delivery_policies
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
store_images
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
store_tags
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- tag_info_id — INT — NOT NULL
- type — ENUM — NOT NULL
tag_info
- id — INT — Primary key — NOT NULL
- content — VARCHAR(50) — NOT NULL
toss_payments
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- payment_key — VARCHAR(255) — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- status — ENUM — NOT NULL
- method — ENUM — 카드, 가상계좌, 간편결제 등
- failure_reason — TEXT
- approved_at — TIMESTAMP
- failed_at — TIMESTAMP
- cancelled_at — TIMESTAMP
- idempotency_key — VARCHAR(255) — NOT NULL
- receipt_url — VARCHAR(500)
- response_raw_daya — JSON
- customer_key — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_coupon
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- coupon_id — INT — NOT NULL
- status — ENUM — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- expired_at — TIMESTAMP — 만료 시 기록
- used_at — TIMESTAMP — 사용 시 기록
user_devices
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- device_id — VARCHAR(255) — NOT NULL — unique
- device_name — VARCHAR(100) — iphone 13 Pro
- device_type — VARCHAR(50) — ios, android, web
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP
user_favorite_store
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- store_id — INT — NOT NULL
- is_notification_enabled — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — INT — Primary key — NOT NULL
- email — VARCHAR(50)
- phone — VARCHAR(20) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- nickname — VARCHAR(100) — 회원가입 시 자동 생성
- login_type — VARCHAR(50) — NOT NULL
- mobile_carrier — VARCHAR(50)
- birth_date — DATE — NOT NULL
- gender — ENUM — NOT NULL
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP — 회원이 탈퇴했을 경우
variants_option_values
- id — INT — Primary key — NOT NULL
- product_variants_id — INT — NOT NULL
- option_values_id — INT — NOT NULL
weather_grid
- id — INT — Primary key — NOT NULL
- mx — INT — NOT NULL
- ny — INT — NOT NULL
상점
- store_documents_id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- file_name — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL