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