wedu
Tables (10)
categories
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
checklists
- checklist_id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → planners.planner_id
- content — VARCHAR(255)
- is_checked — BOOLEAN
community_posts
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255)
- content — TEXT
- image_url — VARCHAR(255)
- created_at — DATETIME
planners
- planner_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- wedding_date — DATE
- d_day — INT
- created_at — DATETIME
products
- product_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → categories.category_id
- name — VARCHAR(255)
- description — TEXT
- price — INT
- location — VARCHAR(255)
- image_url — VARCHAR(255)
- tags — VARCHAR(255)
- created_at — DATETIME
psychological_tests
- test_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- style_result — VARCHAR(255)
- place_result — VARCHAR(255)
- budget_result — VARCHAR(255)
- created_at — DATETIME
recommendations
- recommendation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- test_id — BIGINT — Foreign key → psychological_tests.test_id
- product_id — BIGINT — Foreign key → products.product_id
- reason — TEXT
- created_at — DATETIME
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- product_id — BIGINT — Foreign key → products.product_id
- reservation_date — DATE
- reservation_time — TIME
- status — VARCHAR(255)
- created_at — DATETIME
schedules
- schedule_id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → planners.planner_id
- title — VARCHAR(255)
- schedule_date — DATE
- schedule_time — TIME
- memo — TEXT
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(255)
- provider — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME