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)