공통 프로젝트
테이블 (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