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