week4
테이블 (10)
Copy Of Untitled (review_request_alarm)
- Key (id) — int — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (is_confirmed) — boolean
- Field (body) — varchar(255)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
Untitled (review)
- Key (id) — int — 기본 키 — NOT NULL
- Field (review_contents) — varchar(255)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
- id (restaurant_id) — int — 외래 키 → 책.id — NOT NULL
Untitled (food_type)
- Key (id) — int — 기본 키 — NOT NULL
- Field (type_of_food) — varchar(255)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
Untitled (point_history)
- Key (id) — int — 기본 키 — NOT NULL
- Field (point_history) — varchar(255)
- Field (point_accumulation_date) — datetime(6)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
Untitled (mypage)
- Key (id) — int — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (infromation) — varchar(255)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
Untitled (mission_alarm)
- Key (id) — int — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (is_confirmed) — boolean
- Field (body) — varchar(255)
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
member_mission
- Key (id) — int — 기본 키 — NOT NULL
- id (member_id) — int — 외래 키 → 회원.id — NOT NULL
- id (mission_id) — int — 외래 키 → 카테고리.id — NOT NULL
- Field (created_at) — datetime(6)
- Field2 (updated_At) — datetime(6)
- Field (status) — enum
책 (restaurant)
- id — int — 기본 키 — NOT NULL
- 책이름 (name) — varchar(45)
- 책설명 (tel) — varchar(20)
- Field (address) — varchar(40)
- Field (detail_address) — varachar(40)
- 생성시간 (created_at) — datetime(6)
- 수정시간 (updated_at) — datetime(6)
- Field2 (status) — enum
- Field (inactivated_date) — datetime(6)
카테고리 (mission)
- id — int — 기본 키 — NOT NULL
- 이름 (name) — varchar(40)
- Field (mission_point) — int
- Field (current_mission) — varchar(255)
- Field (finished_mission) — varchar(255)
- 생성시간 (created_at) — datetime(6)
- 수정시간 (updated_at) — datetime(6)
회원 (member)
- id — int — 기본 키 — NOT NULL
- 이름 (name) — varchar(20) — NOT NULL
- Field2 (login_id) — varchar(20)
- Field (password) — varchar(20)
- 전화번호 (phone_num) — varchar(13) — NOT NULL
- 성별 (gender) — enum — NOT NULL
- Field (address) — varchar(40)
- Field (email) — varchar(40)
- Field (detail_address) — varchar(40)
- Field (birthday_date) — date
- Field (point) — int
- 생성시간 (created_at) — datetime(6)
- 수정시간 (updated_at) — datetime(6)
- Field (status) — enum
- Field2 (inactivated_date) — datetime(6)