기말 프로젝트

테이블 (7)

Coupon (coupons)

  • product_id — INT — 외래 키 → Product.id — NOT NULL
  • user_id — INT — 외래 키 → User.id — NOT NULL
  • redeem_time — TIMESTAMP — NOT NULL
  • used_time — TIMESTAMP

Course (courses)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.id — NOT NULL
  • start_time — TIMESTAMP — NOT NULL
  • end_time — TIMESTAMP — NOT NULL
  • submit_time — TIMESTAMP — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • content — TEXT

Gps (gps)

  • user_id — INT — 외래 키 → User.id — NOT NULL
  • time — TIMESTAMP — NOT NULL
  • lat — DECIMAL(9, 6) — NOT NULL
  • lng — DECIMAL(9, 6) — NOT NULL

Place (places)

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • lat — DECIMAL(9,6) — NOT NULL
  • lng — DECIMAL(9,6) — NOT NULL
  • url — VARCHAR(100)
  • address — TEXT — NOT NULL
  • campus — VARCHAR(100) — NOT NULL

Product (products)

  • id — INT — 기본 키 — NOT NULL
  • place_id — INT — 외래 키 → Place.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL

Review (reviews)

  • course_id — INT — 외래 키 → Course.id — NOT NULL
  • user_id — INT — 외래 키 → User.id — NOT NULL
  • submit_time — TIMESTAMP — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT — NOT NULL

User (users)

  • id — INT — 기본 키 — NOT NULL
  • product_id — INT — 외래 키 → Product.id
  • phone — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • campus — VARCHAR(100) — NOT NULL
  • class_no — INT — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • signup_time — TIMESTAMP — NOT NULL
  • point — INT — NOT NULL
  • cumm_walk — INT — NOT NULL
  • curr_walk — INT — NOT NULL