flowerman

Tables (20)

ANNIVERSARY_DELIVERIES

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • subscription_id — BIGINT — Foreign key → SUBSCRIPTIONS.id
  • recipient_name — VARCHAR(50) — NOT NULL
  • recipient_phone — VARCHAR(20) — NOT NULL
  • anniversary_date — DATE — NOT NULL
  • handwritten_letter — VARCHAR(200)
  • plant_id — BIGINT — Foreign key → PLANTS.id
  • status — ENUM('SCHEDULED','SENT','DELIVERED') — NOT NULL
  • created_at — DATETIME — NOT NULL

CALENDAR_ALERTS

  • id — BIGINT — Primary key — NOT NULL
  • calendar_id — BIGINT — Foreign key → PLANT_CALENDARS.id — NOT NULL
  • alert_type — ENUM('WATERING','REPOT','FERTILIZE') — NOT NULL
  • scheduled_date — DATE — NOT NULL
  • is_done — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

COMMUNITY_POSTS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — ENUM('INFO','TRADE','SHARE','FESTIVAL') — NOT NULL
  • location_city — VARCHAR(100)
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(9,6)
  • view_count — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

GROWTH_DIARIES

  • id — BIGINT — Primary key — NOT NULL
  • calendar_id — BIGINT — Foreign key → PLANT_CALENDARS.id — NOT NULL
  • recorded_date — DATE — NOT NULL
  • memo — TEXT
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

NOTICES

  • id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_pinned — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

OAUTH_ACCOUNTS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL — kakao, google, naver
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

ORDERS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • order_number — VARCHAR(50) — NOT NULL
  • total_price — INT — NOT NULL
  • status — ENUM('PENDING','PAID','SHIPPING','DELIVERED','CANCELLED') — NOT NULL
  • delivery_address — VARCHAR(200) — NOT NULL
  • recipient_name — VARCHAR(50) — NOT NULL
  • recipient_phone — VARCHAR(20) — NOT NULL
  • ordered_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ORDER_ITEMS

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → ORDERS.id — NOT NULL
  • product_id — BIGINT — Foreign key → PRODUCTS.id — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL

PAYMENTS

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → ORDERS.id — NOT NULL
  • pg_transaction_id — VARCHAR(100)
  • amount — INT — NOT NULL
  • method — ENUM('CARD','KAKAO_PAY','NAVER_PAY','BANK') — NOT NULL
  • status — ENUM('SUCCESS','FAILED','REFUNDED') — NOT NULL
  • paid_at — DATETIME — NOT NULL

PLANTS

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • scientific_name — VARCHAR(100)
  • birth_flower_date — VARCHAR(5) — MM-DD 형식
  • flower_language — TEXT
  • care_info — TEXT
  • is_toxic_to_pets — TINYINT(1) — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

PLANT_CALENDARS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • plant_id — BIGINT — Foreign key → PLANTS.id
  • plant_nickname — VARCHAR(100) — NOT NULL
  • watering_cycle_days — INT — 물주기 주기(일)
  • repot_date — DATE
  • fertilize_date — DATE
  • created_at — DATETIME — NOT NULL

PLANT_DISEASE_DIAGNOSES

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • ai_result — TEXT
  • prescription — TEXT
  • diagnosed_at — DATETIME — NOT NULL

POST_COMMENT

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • parent_comment_id — BIGINT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

POST_IMAGES

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → COMMUNITY_POSTS.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL

POST_LIKES

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → COMMUNITY_POSTS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • created_at — DATETIME — NOT NULL

PRODUCTS

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → SELLER_PROFILES.id — NOT NULL
  • plant_id — BIGINT — Foreign key → PLANTS.id
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock_quantity — INT — NOT NULL
  • category — ENUM('SEED','SEEDLING','TOOL','ETC') — NOT NULL
  • is_eco_certified — TINYINT(1) — NOT NULL
  • is_group_buy — TINYINT(1) — NOT NULL
  • group_buy_min_qty — INT
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

PRODUCT_IMAGES

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → PRODUCTS.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL

SELLER_PROFILES

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • farm_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • certification_image_url — VARCHAR(255)
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL

SUBSCRIPTIONS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • plan — ENUM('MONTHLY','QUARTERLY','ANNUAL') — NOT NULL
  • status — ENUM('ACTIVE','PAUSED','CANCELLED') — NOT NULL
  • next_delivery_date — DATE
  • delivery_address — VARCHAR(200) — NOT NULL
  • subscribed_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

USERS

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • profile_image_url — VARCHAR(255)
  • role — ENUM('USER','SELLER','ADMIN') — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL