umcspringstudy
Tables (11)
food (음식 종류)
- food_uuid (foodUuid) — bigint — Primary key — NOT NULL
- korean_food (koreanFood) — tinyint(1) — NOT NULL
- japanese_food (japaneseFood) — tinyint(1) — NOT NULL
- chinese_food (chineseFood) — tinyint(1) — NOT NULL
- western_food (westernFood) — tinyint(1) — NOT NULL
- chicken_food (chickenFood) — tinyint(1) — NOT NULL
- street_food (streetFood) — tinyint(1) — NOT NULL
- meat_food (meatFood) — tinyint(1) — NOT NULL
- lunchbox_food (lunchboxFood) — tinyint(1) — NOT NULL
- midnight_food (midnightFood) — tinyint(1) — NOT NULL
- fast_food (fastFood) — tinyint(1) — NOT NULL
- dessert_food (dessertFood) — tinyint(1) — NOT NULL
- asian_food (asianFood) — tinyint(1) — NOT NULL
inquiry (문의)
- inquiry_uuid (inquiryUuid) — bigint — Primary key — NOT NULL
- inquiry_title (inquiryTitle) — varchar(40) — NOT NULL
- inquiry_body (inquiryBody) — text — NOT NULL
- created_at (createdAt) — timestamp — NOT NULL
- member_uuid (memberUuid) — bigint — Foreign key → member.member_uuid — NOT NULL
inquiryphotos (문의 사진 첨부)
- inquiryphotos_uuid (inquiryphotosUuid) — bigint — Primary key — NOT NULL
- inquiry_uuid (inquiryUuid) — bigint — Foreign key → inquiry.inquiry_uuid — NOT NULL
- inquiryphotos_url (inquiryphotosUrl) — text — NOT NULL
- photos_uuid (photosUuid) — varchar(255) — NOT NULL
location (동네)
- location_uuid (locationUuid) — bigint — Primary key — NOT NULL
- member_uuid (memberUuid) — bigint — Foreign key → member.member_uuid — NOT NULL
- location_name (locationName) — varchar(10) — NOT NULL
member (회원)
- member_uuid (memberUuid) — bigint — Primary key — NOT NULL
- member_name (memberName) — varchar(10) — NOT NULL
- member_gender (memberGender) — varchar(10) — NOT NULL
- member_birth (memberBirth) — date — NOT NULL
- member_address (memberAddress) — varchar(255) — NOT NULL
- member_point (memberPoint) — int — NOT NULL
- member_nickname (memberNickname) — varchar(20) — NOT NULL
- member_email (memberEmail) — varchar(255) — NOT NULL
- member_number (memberNumber) — varchar(15) — NOT NULL
- provider — varchar(255) — NOT NULL
- provider_id (providerId) — varchar(255) — NOT NULL
- food_uuid (foodUuid) — bigint — Foreign key → food.food_uuid — NOT NULL
- created_at (createdAt) — timestamp — NOT NULL
- updated_at (updatedAt) — timestamp — NOT NULL
- member_status (memberStatus) — varchar(15) — NOT NULL
- inactive_date (inactiveDate) — timestamp
- member_pasword (memberPassword) — varchar(255) — NOT NULL
mission (미션)
- mission_uuid (missionUuid) — bigint — Primary key — NOT NULL
- member_uuid (memberUuid) — bigint — Foreign key → member.member_uuid — NOT NULL
- shop_uuid (shopUuid) — bigint — Foreign key → shop.shop_uuid — NOT NULL
- mission_start (missionStart) — date — NOT NULL
- mission_period (missionPeriod) — date
- mission_end (missionEnd) — date — NOT NULL
- mission_money (missionMoney) — int — NOT NULL
- mission_point (missionPoint) — int — NOT NULL
- mission_active (missionActive) — varchar(10) — NOT NULL — 진행중, 성공
- mission_number (missionNumber) — bigint — NOT NULL
missionalarm (미션 알림)
- missionalarm_uuid (missionalarmUuid) — bigint — Primary key — NOT NULL
- member_uuid (memberUuid) — bigint — Foreign key → member.member_uuid — NOT NULL
- missionalarm_title (missionalarmTitle) — varchar(40) — NOT NULL
- missionalarm_body (missionalarmBody) — varchar(255) — NOT NULL
- is_confirmed (isConfirmed) — tinyint(1) — NOT NULL
- created_at (createdAt) — timestamp — NOT NULL
- updated_at (updatedAt) — timestamp — NOT NULL
review (리뷰)
- review_uuid (reviewUuid) — bigint — Primary key — NOT NULL
- shop_uuid (shopUuid) — bigint — Foreign key → shop.shop_uuid — NOT NULL
- mission_uuid (missionUuid) — bigint — Foreign key → mission.mission_uuid — NOT NULL
- review_star (reviewStar) — decimal(2, 1) — NOT NULL
- created_at (createdAt) — timestamp — NOT NULL
- review_body (reviewBody) — text — NOT NULL
reviewalarm (리뷰 알림)
- reviewalarm_uuid (reviewalarmUuid) — bigint — Primary key — NOT NULL
- is_confirmed (isConfirmed) — tinyint(1) — NOT NULL
- created_at (createdAt) — timestamp — NOT NULL
- updated_at (updatedAt) — timestamp — NOT NULL
- reviewalarm_title (reviewalarmTitle) — varchar(40) — NOT NULL
- reviewalarm_body (reviewalarmBody) — varchar(255) — NOT NULL
- member_uuid (memberUuid) — bigint — Foreign key → member.member_uuid — NOT NULL
reviewphotos (리뷰 사진)
- reviewphotos_uuid (reviewphotosUuid) — bigint — Primary key — NOT NULL
- review_uuid (reviewUuid) — bigint — Foreign key → review.review_uuid — NOT NULL
- reviewphotos_url (reviewphotosUrl) — text — NOT NULL
- photos_uuid (photosUuid) — varchar(255) — NOT NULL
shop (가게)
- shop_uuid (shopUuid) — bigint — Primary key — NOT NULL
- food_uuid (foodUuid) — bigint — Foreign key → food.food_uuid — NOT NULL
- shop_name (shopName) — varchar(255) — NOT NULL