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