umc_hackathon3_team2

테이블 (7)

Center (센터)

  • center_id — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • category (category_id) — BIGINT(20) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone_num — VARCHAR(255) — NOT NULL
  • region_id — BIGINT(20) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • Field (open_time) — DATETIME — NOT NULL
  • Field5 (close_time) — DATETIME — NOT NULL
  • create_time (Field2) — DATETIME — NOT NULL
  • update_time (Field3) — DATETIME
  • status (Field4) — VARCHAR(255) — NOT NULL

Center_reservation (Untitled5)

  • id (Key) — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • center_id (Field) — BIGINT(20) — NOT NULL
  • max_num (Field2) — INT — NOT NULL
  • start_time (Field3) — INT — NOT NULL
  • end_time (Field4) — INT — NOT NULL
  • price (Field5) — INT — NOT NULL
  • create_time (Field6) — DATETIME — NOT NULL
  • update_time (Field7) — DATETIME
  • status (Field8) — VARCHAR(255) — NOT NULL
  • center_id — BIGINT(20) — 외래 키 → Center.center_id — NOT NULL — Auto Increament

Region

  • region_id (id) — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • name — VARCHAR(255) — NOT NULL
  • create_time — DATETIME — NOT NULL
  • update_time — DATETIME
  • status — VARCHAR(255) — NOT NULL
  • center_id — BIGINT(20) — 외래 키 → Center.center_id — NOT NULL — Auto Increament

Reservation (Untitled2)

  • reservation_id (Key) — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • 센터ID (Field) — BIGINT(20) — NOT NULL
  • reservation_date — TIMESTAMP — NOT NULL
  • participation_date — TIMESTAMP — NOT NULL
  • price — INT — NOT NULL
  • create_time — DATETIME — NOT NULL
  • update_time — DATETIME
  • status — VARCHAR(255) — NOT NULL
  • user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL — Auto Increament
  • center_id — BIGINT(20) — 외래 키 → Center.center_id — NOT NULL — Auto Increament
  • id (Key2) — BIGINT(20) — 외래 키 → Center_reservation.id — NOT NULL — Auto Increament

User (유저)

  • user_id — bigint(20) — 기본 키 — NOT NULL — Auto Increament
  • name — VARCHAR(255) — NOT NULL
  • phone_num — VARCHAR(255) — NOT NULL
  • create_time (Field) — DATETIME — NOT NULL
  • update_time (Field2) — DATETIME
  • status (Field3) — VARCHAR(255) — NOT NULL

Zzim (Untitled)

  • zzim_id (Key) — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • user_id (Field) — BIGINT(20) — NOT NULL
  • center_id (Field2) — BIGINT(20) — NOT NULL
  • create_time (Field3) — DATETIME — NOT NULL
  • update_time (Field4) — DATETIME
  • status (Field5) — VARCHAR(255) — NOT NULL
  • center_id — BIGINT(20) — 외래 키 → Center.center_id — NOT NULL — Auto Increament
  • user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL — Auto Increament

카테고리 (Category)

  • 카테고리 ID (id) — BIGINT(20) — 기본 키 — NOT NULL — Auto Increament
  • 이름 (name) — VARCHAR(255) — NOT NULL
  • create_time — DATETIME — NOT NULL
  • update_time — DATETIME
  • status — VARCHAR(255) — NOT NULL
  • center_id — BIGINT(20) — 외래 키 → Center.center_id — NOT NULL — Auto Increament