공통 프로젝트

테이블 (16)

Applicants (applicants)

  • uid — BIGINT — 기본 키 — NOT NULL
  • recruitment_uid — BIGINT — 외래 키 → Recruitments.uid — NOT NULL
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL
  • content — TEXT
  • possible_start_date — DATETIME
  • minimum_working_period — VARCHAR(50)
  • date_created — DATETIME
  • date_read — DATETIME
  • tags — VARCHAR(100)
  • instagram_link — VARCHAR(255)

Authorities (authorities)

  • authority_anme — ENUM('admin','auth_user','user') — 기본 키 — NOT NULL

Comments (comments)

  • uid — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('tour','house')
  • type_uid — BIGINT
  • content — TEXT
  • is_staff — BOOLEAN
  • date_created — DATETIME
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL

Guest Houses (guest_houses)

  • uid — BIGINT — 기본 키 — NOT NULL
  • guest_house_name — VARCHAR(25)
  • email — VARCHAR(255)
  • phone — VARCHAR(25)
  • address — VARCHAR(255)
  • address_detail (address_detailad) — VARCHAR(255)
  • introduction — TEXT
  • date_created — DATETIME
  • representative_uid — BIGINT — 외래 키 → Users.uid — NOT NULL

Images (images)

  • uid — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('tour','tour_review','house','resume')
  • type_uid — BIGINT
  • img_path — VARCHAR(255)

Interest Areas (interest_areas)

  • uid — BIGINT — 기본 키 — NOT NULL
  • userUid — BIGINT — 외래 키 → Users.uid — NOT NULL

Recruitments (recruitments)

  • uid — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • date_created — DATETIME
  • date_updated — DATETIME
  • welfare (welfaret) — TEXT
  • guest_house_uid — BIGINT — 외래 키 → Guest Houses.uid — NOT NULL

Resumes (resumes)

  • uid — BIGINT — 기본 키 — NOT NULL
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL
  • content — TEXT
  • possible_start_date — DATETIME
  • minimum_working_period (Field) — VARCHAR(25)
  • auto_apply — BOOLEAN
  • date_created — DATETIME
  • tags — VARCHAR(100)
  • instagram_link — VARCHAR(255)

Scraps (scraps)

  • uid — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('tour','recruitment')
  • type_uid — BIGINT
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL

Social Logins (social_logins)

  • uid (user_uid) — BIGINT — 외래 키 → Users.uid — NOT NULL
  • access_token — VARCHAR(255)
  • type — ENUM('kakao','naver','google','apple')

Staff Reviews (staff_reviews)

  • uid — BIGINT — 기본 키 — NOT NULL
  • content — TEXT
  • recommendation — BOOLEAN
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL
  • guest_house_uid — BIGINT — 외래 키 → Guest Houses.uid — NOT NULL

Staff histories (staff_histories)

  • uid — BIGINT — 기본 키 — NOT NULL
  • start_date — DATETIME
  • end_date — DATETIME
  • on_duty — BOOLEAN
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL
  • guest_house_uid — BIGINT — 외래 키 → Guest Houses.uid — NOT NULL

Tourist Spot Reviews (tourist_spot_reviews)

  • uid — BIGINT — 기본 키 — NOT NULL
  • content — TEXT
  • rating — INT
  • date_created — DATETIME
  • tourist_spot_description — BIGINT — 외래 키 → Tourist Spots.uid — NOT NULL
  • user_uid — BIGINT — 외래 키 → Users.uid — NOT NULL

Tourist Spots (tourist_spots)

  • uid — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(25)
  • address — VARCHAR(255)
  • description — VARCHAR(255)
  • lat — DOUBLE
  • lng — DOUBLE
  • review_count — INT
  • total_rating — Double
  • link — VARCHAR(255)

Users (users)

  • uid — BIGINT — 기본 키 — NOT NULL
  • user_id — VARCHAR(100)
  • password — VARCHAR(255)
  • username — VARCHAR(25)
  • email — VARCHAR(255)
  • email_receive_allow — BOOLEAN
  • phone — VARCHAR(25)
  • phone_receive_allow — BOOLEAN
  • date_created — DATETIME
  • gender — ENUM('M','F','X')
  • birth — DATETIME
  • age — INT
  • instagram_link — VARCHAR(100)
  • profile_img_url — VARCHAR(255)
  • refresh_token — VARCHAR(255)

Works (works)

  • uid — BIGINT — 기본 키 — NOT NULL
  • work_name — VARCHAR(25)
  • personnel — INT
  • work_type — VARCHAR(100)
  • work_description — TEXT
  • minimum_work_period — VARCAHR(50)
  • work_time
  • recruitment_uid — BIGINT — 외래 키 → Recruitments.uid — NOT NULL