모먹?

테이블 (19)

TB_BOARD_COMMENT

  • id — BIGINT
  • post_id — BIGINT — 외래 키 → TB_BOARD_POST.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_post_id
  • INDEX — idx_user_id

TB_BOARD_POST

  • id — BIGINT
  • company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • like_count — INT
  • comment_count — INT
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_company_id
  • INDEX — idx_user_id

TB_BOARD_POST_LIKE

  • id — BIGINT
  • post_id — BIGINT — 외래 키 → TB_BOARD_POST.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_post_id
  • INDEX — idx_user_id

TB_COMPANY

  • id — BIGINT
  • company_group_id — BIGINT — 외래 키 → TB_COMPANY_GROUP.id
  • name — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_company_group_id

TB_COMPANY_DOMAIN

  • id — BIGINT
  • company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
  • domain — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_company_id

TB_COMPANY_GROUP

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_EMAIL_VERIFICATION

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • verification_code — VARCHAR(20) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • expired_at — DATETIME
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_email

TB_LOCATION_VERIFICATION

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • verified_at — DATETIME
  • expired_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_user_id

TB_PUSH_NOTIFICATION

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • type — VARCHAR(50)
  • title — VARCHAR(255)
  • body — TEXT
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • is_read — BOOLEAN
  • sent_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_user_id

TB_PUSH_TOKEN

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • device_type — VARCHAR(50)
  • token — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_user_id

TB_RESTAURANT

  • id — BIGINT
  • external_id — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(255)
  • address — VARCHAR(500)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • phone — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

TB_RESTAURANT_BOOKMARK

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_user_id
  • INDEX — idx_restaurant_id

TB_RESTAURANT_PHOTO

  • id — BIGINT
  • restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • source — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_restaurant_id

TB_REVIEW

  • id — BIGINT
  • restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • recommended_menu — VARCHAR(255)
  • is_anonymous — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_restaurant_id
  • INDEX — idx_user_id
  • INDEX — idx_company_id

TB_REVIEW_LIKE

  • id — BIGINT
  • review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_review_id
  • INDEX — idx_user_id

TB_REVIEW_PHOTO

  • id — BIGINT
  • review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_review_id

TB_REVIEW_REPORT

  • id — BIGINT
  • review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_review_id
  • INDEX — idx_user_id

TB_USER

  • id — BIGINT
  • company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • role — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_company_id

TB_USER_PROFILE_IMAGE

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_user_id