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