MealStack

Tables (9)

cart_items

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • product_id — BIGINT — Foreign key → products.id
  • quantity — INTEGER — NOT NULL
  • added_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(user_id, — product_id)

order_items

  • id — BIGSERIAL — Primary key
  • order_id — BIGINT — Foreign key → orders.id
  • product_id — BIGINT — Foreign key → products.id
  • quantity — INTEGER — NOT NULL
  • unit_price — INTEGER — NOT NULL
  • total_price — INTEGER — NOT NULL
  • created_at — TIMESTAMP

orders

  • id (주문번호) — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • subscription_id — BIGINT — Foreign key → user_subscriptions.id
  • order_number — VARCHAR(50) — NOT NULL
  • order_type — VARCHAR(20) — NOT NULL
  • total_amount — INTEGER — NOT NULL
  • status — VARCHAR(20)
  • payment_method — VARCHAR(50)
  • shipping_address — TEXT
  • tracking_number — VARCHAR(100)
  • ordered_at — TIMESTAMP
  • paid_at — TIMESTAMP
  • shipped_at — TIMESTAMP
  • delivered_at — TIMESTAMP
  • cancelled_at — TIMESTAMP

products

  • id — BIGSERIAL — Primary key
  • name — VARCHAR(255) — NOT NULL
  • price — INTEGER — NOT NULL
  • image_url — TEXT
  • description — TEXT
  • nutrition_protein — VARCHAR(10)
  • nutrition_calories — VARCHAR(10)
  • nutrition_carbs — VARCHAR(10)
  • nutrition_fat — VARCHAR(10)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

subscription_plans

  • id — VARCHAR(50) — Primary key
  • name — VARCHAR(100) — NOT NULL
  • price — INTEGER — NOT NULL
  • original_price — INTEGER
  • period — VARCHAR(20) — NOT NULL
  • description — TEXT
  • features — TEXT
  • is_popular — BOOLEAN
  • savings — VARCHAR(100)
  • badge — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

user_addresses

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • recipient_name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • detail_address — VARCHAR(200)
  • zip_code — VARCHAR(10)
  • is_default — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_payment_methods

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • payment_type — VARCHAR(50) — NOT NULL
  • card_number_masked — VARCHAR(20)
  • card_company — VARCHAR(50)
  • is_default — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_subscriptions

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • plan_id — VARCHAR(50) — Foreign key → subscription_plans.id
  • status — VARCHAR(20)
  • price — INTEGER — NOT NULL
  • next_payment_date — DATE
  • started_at — TIMESTAMP
  • paused_at — TIMESTAMP
  • resumed_at — TIMESTAMP
  • cancelled_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — BIGSERIAL — Primary key
  • kakao_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • profile_image_url — TEXT
  • login_type — VARCHAR(20)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP
  • last_login_at — TIMESTAMP
  • updated_at — TIMESTAMP