기말 프로젝트
테이블 (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