로랄로랄
테이블 (12)
ANNIVERSARY_DELIVERIES
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- subscription_id — NUMBER — 외래 키 → SUBSCRIPTIONS.id
- recipient_name — VARCHAR2(50) — NOT NULL
- recipient_phone — VARCHAR2(20) — NOT NULL
- anniversary_date — DATE — NOT NULL
- handwritten_letter — VARCHAR2(200)
- plant_id — VARCHAR2(24)
- status — VARCHAR2(10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
COMMUNITY_POSTS
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- category — VARCHAR2(10) — NOT NULL
- image_url — VARCHAR2(255)
- location_city — VARCHAR2(100)
- latitude — NUMBER(9,6)
- longitude — NUMBER(9,6)
- view_count — NUMBER — NOT NULL
- is_active — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
GROWTH_DIARIES
- id — NUMBER
- calendar_id — NUMBER — 외래 키 → PLANT_CALENDARS.id — NOT NULL
- recorded_date — DATE — NOT NULL
- memo — CLOB
- image_url — VARCHAR2(255)
- created_at — TIMESTAMP — NOT NULL
LIKES
- id — NUMBER
- target_type — VARCHAR2(30) — NOT NULL
- target_id — NUMBER — NOT NULL
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
OAUTH_ACCOUNTS
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- provider — VARCHAR2(30) — NOT NULL
- provider_user_id — VARCHAR2(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
ORDERS
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- order_number — VARCHAR2(50) — NOT NULL
- total_price — NUMBER — NOT NULL
- status — VARCHAR2(10) — NOT NULL
- delivery_address — VARCHAR2(200) — NOT NULL
- recipient_name — VARCHAR2(50) — NOT NULL
- recipient_phone — VARCHAR2(20) — NOT NULL
- ordered_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ORDER_ITEMS
- id — NUMBER
- order_id — NUMBER — 외래 키 → ORDERS.id — NOT NULL
- product_id — NUMBER — 외래 키 → PRODUCTS.id — NOT NULL
- quantity — NUMBER — NOT NULL
- unit_price — NUMBER — NOT NULL
PAYMENTS
- id — NUMBER
- order_id — NUMBER — 외래 키 → ORDERS.id — NOT NULL
- pg_transaction_id — VARCHAR2(100)
- amount — NUMBER — NOT NULL
- method — VARCHAR2(15) — NOT NULL
- status — VARCHAR2(10) — NOT NULL
- paid_at — TIMESTAMP — NOT NULL
PLANT_CALENDARS
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- plant_id — VARCHAR2(24)
- plant_nickname — VARCHAR2(100) — NOT NULL
- watering_cycle_days — NUMBER
- watering_next_date — DATE
- watering_is_done — NUMBER(1) — NOT NULL
- repot_date — DATE
- repot_is_done — NUMBER(1) — NOT NULL
- fertilize_date — DATE
- fertilize_is_done — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
PRODUCTS
- id — NUMBER
- seller_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- plant_id — VARCHAR2(24)
- name — VARCHAR2(200) — NOT NULL
- description — CLOB
- price — NUMBER — NOT NULL
- stock_quantity — NUMBER — NOT NULL
- category — VARCHAR2(10) — NOT NULL
- is_eco_certified — NUMBER(1) — NOT NULL
- is_group_buy — NUMBER(1) — NOT NULL
- group_buy_min_qty — NUMBER
- is_active — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
SUBSCRIPTIONS
- id — NUMBER
- user_id — NUMBER — 외래 키 → USERS.id — NOT NULL
- plan — VARCHAR2(10) — NOT NULL
- status — VARCHAR2(10) — NOT NULL
- next_delivery_date — DATE
- delivery_address — VARCHAR2(200) — NOT NULL
- subscribed_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
USERS
- id — NUMBER
- email — VARCHAR2(100) — NOT NULL
- password_hash — VARCHAR2(255)
- nickname — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(20)
- profile_image_url — VARCHAR2(255)
- role — VARCHAR2(10) — NOT NULL
- is_active — NUMBER(1) — NOT NULL
- farm_name — VARCHAR2(100)
- seller_description — VARCHAR2(500)
- certification_image_url — VARCHAR2(255)
- seller_status — VARCHAR2(10)
- approved_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL