floral

Tables (14)

ANNIVERSARY_DELIVERIES

  • id — NUMBER
  • user_id — NUMBER — Foreign key → USERS.id — NOT NULL
  • subscription_id — NUMBER — Foreign key → 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

COMMENTS

  • id — NUMBER
  • target_type — VARCHAR2(30) — NOT NULL
  • target_id — NUMBER — NOT NULL
  • user_id — NUMBER — Foreign key → USERS.id — NOT NULL
  • parent_comment_id — NUMBER — Foreign key → COMMENTS.id
  • content — CLOB — NOT NULL
  • is_active — NUMBER(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

COMMUNITY_POSTS

  • id — NUMBER
  • user_id — NUMBER — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • category — VARCHAR2(10) — NOT NULL
  • 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 — Foreign key → 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 — Foreign key → USERS.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

NOTICES

  • id — NUMBER
  • admin_id — NUMBER — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • is_pinned — NUMBER(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

OAUTH_ACCOUNTS

  • id — NUMBER
  • user_id — NUMBER — Foreign key → 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 — Foreign key → 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 — Foreign key → ORDERS.id — NOT NULL
  • product_id — NUMBER — Foreign key → PRODUCTS.id — NOT NULL
  • quantity — NUMBER — NOT NULL
  • unit_price — NUMBER — NOT NULL

PAYMENTS

  • id — NUMBER
  • order_id — NUMBER — Foreign key → 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 — Foreign key → 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 — Foreign key → 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 — Foreign key → 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