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