for 5th umc erd test

테이블 (8)

Copy Of Copy Of Copy Of Copy Of Copy Of 유저2 (Challenge)

  • Key (review_id) — bigint — 기본 키 — NOT NULL
  • Key (member_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Key (mission_id) — bigint — 외래 키 → Copy Of 유저.Key — NOT NULL
  • Field (result) — boolean
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL

Copy Of Copy Of Copy Of Copy Of 유저2 (review)

  • Key (review_id) — bigint — 기본 키 — NOT NULL
  • Key (member_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Key (restaurant_id) — bigint — 외래 키 → Copy Of Copy Of 유저.Key — NOT NULL
  • Field (rate) — float — 별점 점수
  • Field2 (content) — varchar(100) — 리뷰 내용
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL

Copy Of Copy Of Copy Of Copy Of 유저22 (Image)

  • Key (image_id) — bigint — 기본 키 — NOT NULL
  • Key (restaurant_id) — bigint — 외래 키 → Copy Of Copy Of 유저.Key
  • Key (review_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of Copy Of 유저2.Key
  • Key (inquiry_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of 유저2.Key — NOT NULL
  • Field (image_url) — string(100) — NOT NULL
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL
  • Field (dtype) — varchar(20) — NOT NULL — RESTAURANT, REVIEW, INQUIRY

Copy Of Copy Of Copy Of 유저2 (Inquiry)

  • Key (inquiry_id) — bigint — 기본 키 — NOT NULL
  • Key (member_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Field (title) — varchar(20) — NOT NULL
  • Field (content) — varchar(200) — NOT NULL
  • Field (type) — varchar(10) — NOT NULL
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL

Copy Of Copy Of 유저 (Restaurant)

  • Key (restaurant_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field2 (type) — varchar(20) — NOT NULL — 중식당, 한식당, 일식당 기타
  • Field3 (point_x) — int — NOT NULL — 식당 X 좌표값
  • Field (point_y) — int — NOT NULL — 식당 Y 좌표값
  • Field (city) — varchar(20) — NOT NULL
  • Field2 (street) — varchar(20) — NOT NULL
  • Field3 (zipcode) — varchar(20) — NOT NULL
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL

Copy Of Copy Of 유저2 (Alarm)

  • Key (alarm_id) — bigint — 기본 키 — NOT NULL
  • Key (member_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Key (mission_id) — bigint — 외래 키 → Copy Of 유저.Key
  • Key (review_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of Copy Of 유저2.Key
  • Key (inquiry_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of 유저2.Key
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL
  • Field (dtype) — varchar(6) — EVENT(MISSION??), REVIEW, INQUIRY

Copy Of 유저 (Mission)

  • Key (mission_id) — bigint — 기본 키 — NOT NULL
  • Key (restaurant_id) — bigint — 외래 키 → Copy Of Copy Of 유저.Key — NOT NULL
  • Field (amount_condition) — int — NOT NULL — 금액 조건
  • Field2 (point_award) — int — NOT NULL — 수령 포인트
  • Field (deadline) — datetime — NOT NULL
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL

유저 (Member)

  • Key (member_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field (nickname) — varchar(20) — NOT NULL
  • Field2 (gender) — varchar(20) — NOT NULL — MALE, FEMALE, NULL
  • Field3 (birthday) — datetime — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (phone_num) — string
  • Field (city) — varchar(10) — NOT NULL
  • Field2 (street) — varchar(20) — NOT NULL
  • Field3 (zipcode) — varchar(20) — NOT NULL — 우편 번호
  • Field (status) — varchar(10) — NOT NULL — ACTIVE, INACTIVE, DELETED
  • Field (created_date) — datetime(6) — NOT NULL
  • Field (last_modified_date) — datetime(6) — NOT NULL