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