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