OURS

Tables (22)

course (코스)

  • course_index (Key) — serial, primary key — Primary key — NOT NULL
  • user_index (Key2) — serial — Foreign key → users.user_index — NOT NULL
  • title (Field6) — VARCHAR(50), not null
  • start_at (Field4) — DATETIME
  • end_at (Field5) — DATETIME
  • in_progress (Field2) — TINYINT(1) not null
  • is_finished (Field3) — TINYINT(1), not null
  • created_at (Field) — TIMESTAMP, not null

course_bookmark (북마크한 코스)

  • course_bookmark_index (Key2) — serial, primary key — Primary key — NOT NULL
  • user_index (Key3) — serial — Foreign key → users.user_index — NOT NULL
  • title (Field) — VARCHAR(50), not null
  • created_at (Field2) — TIMESTAMP, not null

course_in_bookmark (코스 북마크에 들어갈 코스)

  • course_in_bookmark_index (Key) — serial, primary key — Primary key — NOT NULL
  • course_index (Key2) — serial, primary key — Foreign key → course.course_index — NOT NULL
  • course_bookmark_index (Key22) — serial, primary key — Foreign key → course_bookmark.course_bookmark_index — NOT NULL
  • created_at (Field) — TIMESTAMP, not null

course_magazine (코스 매거진)

  • course_magazine_index (Key) — serial, primary key — Primary key — NOT NULL
  • user_index (Key2) — serial, primary key — Foreign key → users.user_index — NOT NULL
  • title (Field) — VARCHAR(50), not null
  • img_url (Field2) — VARCHAR(255)
  • contents (Field4) — TEXT, not null
  • created_at (Field3) — TIMESTAMP, not null

course_magazine_favorite (좋아요한 코스 매거진)

  • course_magazine_favorite_index (Key) — serial, primary key — Primary key — NOT NULL
  • user_index (Key2) — serial, primary key — Foreign key → users.user_index — NOT NULL
  • course_magazine_index (Key3) — serial, primary key — Foreign key → course_magazine.course_magazine_index — NOT NULL
  • (user_index, course_magazine_index) (Field) — unique

hashtag (해시태그)

  • hashtag_index (Key) — serial, primary key — Primary key — NOT NULL
  • name (Field) — VARCHAR(30), not null
  • img_url (Field2) — VARCHAR(255), not null

hashtag_at_place (장소에 매핑된 해시태그 리스트)

  • hashtag_at_place_index (Key3) — serial, primary key — Primary key — NOT NULL
  • hashtag_index (Key) — serial — Foreign key → hashtag.hashtag_index — NOT NULL
  • place_index (Key2) — serial — Foreign key → place.place_index — NOT NULL
  • (hashtag_index, place_index) (Field) — unique

menu (메뉴)

  • menu_index (Key) — serial, primary key — Primary key — NOT NULL
  • place_index (Key2) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • name (Field) — VARCHAR(30), not null
  • price (Field2) — Integer, not null
  • img_url (Field3) — VARCHAR(255)

place (장소)

  • place_index (Key) — serial, primary key — Primary key — NOT NULL
  • elatsic_index (Field) — VARCHAR(30), not null
  • name (Field2) — VARCHAR(30), not null
  • category (Field4) — VARCHAR(20)
  • img_url (Field3) — VARCHAR(255)
  • open_time (Field5) — long text

place_bookmark (공간 북마크)

  • place_bookmark_index (Key) — serial, primary key — Primary key — NOT NULL
  • user_index (Key3) — serial — Foreign key → users.user_index — NOT NULL
  • title (Field2) — VARCHAR(50), not null
  • created_at (Field) — TIMESTAMP, not null

place_favorite (좋아요한 공간)

  • place_favorite_index (Key3) — serial, primary key — Primary key — NOT NULL
  • user_index (Key2) — serial — Foreign key → users.user_index — NOT NULL
  • place_index (Key) — serial — Foreign key → place.place_index — NOT NULL
  • (place_index, user_index) (Field) — unique

place_img (장소 이미지)

  • place_img_index (Key) — serial, primary key — Primary key — NOT NULL
  • place_index (Key2) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • img_url (Field) — VARCHAR(255), not null
  • created_at (Field2) — TIMESTAMP, not null

place_in_course_magazine (코스 매거진에 들어갈 공간 리스트)

  • place_in_course_magazine_index (Key) — serial, primary key — Primary key — NOT NULL
  • course_magazine_index (Key2) — serial, primary key — Foreign key → course_magazine.course_magazine_index — NOT NULL
  • place_index (Key3) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • contents (Field2) — TEXT, not null
  • visit_order (Field) — INT, not null

place_open (현재 영업중인 공간)

  • place_open_index (Key3) — serial, primary key — Primary key — NOT NULL
  • user_index (Key2) — serial — Foreign key → users.user_index — NOT NULL
  • place_index (Key) — serial — Foreign key → place.place_index — NOT NULL
  • (place_index, user_index) (Field) — unique
  • created_at (Field2) — TIMESTAMP, not null

place_review (한줄 평)

  • review_index (Key) — serial, primary key — Primary key — NOT NULL
  • user_index (Key3) — serial, primary key — Foreign key → users.user_index — NOT NULL
  • place_index (Key2) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • contents (Field) — VARCHAR(155), not null
  • created_at (Field2) — TIMESTAMP, not null

place_review_complain (한줄평 신고)

  • place_review_complain_index (Key3) — serial, primary key — Primary key — NOT NULL
  • review_index (Key) — serial — Foreign key → place_review.review_index — NOT NULL
  • user_index (Key4) — serial — Foreign key → users.user_index — NOT NULL
  • (review_index, user_index) (Field) — unique

place_review_favorite (한줄평 좋아요)

  • place_review_favorite_index (Key3) — serial, primary key — Primary key — NOT NULL
  • review_index (Key) — serial — Foreign key → place_review.review_index — NOT NULL
  • user_index (Key4) — serial — Foreign key → users.user_index — NOT NULL
  • (review_index, user_index) (Field) — unique

places_in_bookmark (북마크에 들어갈 장소 리스트)

  • places_in_bookmark_index (Key) — serial, primary key — Primary key — NOT NULL
  • place_bookmark_index (Key3) — serial — Foreign key → place_bookmark.place_bookmark_index — NOT NULL
  • place_index (Key2) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • (place_index, place_bookmark_index) (Field2) — unique
  • created_at (Field) — TIMESTAMP, not null

places_in_course (코스에 들어갈 공간 리스트)

  • places_in_course_index (Key3) — serial, primary key — Primary key — NOT NULL
  • course_index (Key2) — serial — Foreign key → course.course_index — NOT NULL
  • place_index (Key) — serial, primary key — Foreign key → place.place_index — NOT NULL
  • visit_order (Field2) — INT, not null
  • start_at (Field3) — DATETIME
  • time_required (Field5) — INT
  • day (Field4) — INT
  • transportation_time (Field6) — INT
  • created_at (Field) — TIMESTAMP, not null

term_agreement (이용약관 동의)

  • term_agreement_index (Key) — serial, primary key — Primary key — NOT NULL
  • term_index (Key2) — small serial, primary key — Foreign key → terms_of_service.term_index — NOT NULL
  • user_index (Key3) — serial, primary key — Foreign key → users.user_index — NOT NULL
  • created_at (Field) — TIMESTAMP, not null

terms_of_service (이용약관 리스트)

  • term_index (Key) — small serial, primary key — Primary key — NOT NULL
  • title (Field) — VARCHAR(50), not null
  • contents (Field2) — TEXT, not null
  • type (Field4) — VARCHAR(20), not null
  • version (Field3) — INT, not null
  • required (Field6) — TINY INT(1), not null
  • created_at (Field5) — TIMESTAMP, not null

users (유저)

  • user_index (Key) — serial, primary key — Primary key — NOT NULL
  • email (Field) — VARCHAR(25), unique, not null
  • nickname (Field2) — VARCHAR(20), unique, not null, min = 3, max = 20
  • phone_number (Field3) — VARCHAR(15), not null
  • gender (Field6) — TINY INT(1), not null
  • birthday (Field7) — DATETIME, not null
  • img_url (Field8) — VARCHAR(255)
  • created_at (Field4) — TIMESTAMP, not null
  • last_login_at (Field5) — TIMESTAMP, not null