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