flora

Tables (17)

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

COMMENT

  • id — BIGINT — Primary key — NOT NULL — 대댓글용
  • target_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • parent_comment_id — BIGINT — POST 등
  • content — TEXT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_comments_target

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

IMAGES

  • id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL — POST, PRODUCT 등
  • target_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL
  • INDEX — idx_images_target

LIKES

  • id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_likes_target

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 — 물주기 주기(일)
  • watering_next_date — DATE
  • watering_is_done — TINYINT(1) — NOT NULL
  • repot_date — DATE
  • repot_is_done — TINYINT(1) — NOT NULL
  • fertilize_date — DATE
  • fertilize_is_done — TINYINT(1) — NOT NULL
  • 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

PRODUCTS

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → USERS.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

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
  • farm_name — VARCHAR(100)
  • seller_description — VARCHAR(500)
  • certification_image_url — VARCHAR(255)
  • seller_status — ENUM('PENDING','APPROVED','REJECTED')
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL