crew station
Tables (38)
Untitled13
- id (Key) — Foreign key → tbl_country_diary.id — NOT NULL
- id (Key2) — Foreign key → tbl_country.id — NOT NULL
Untitled21
- id (Key) — Foreign key → tbl_diary.id — NOT NULL
- id (Key2) — Foreign key → tbl_country.id — NOT NULL
diary_file_tag (Untitled15)
- Key2 — Foreign key → tbl_diary_file.Key2 — NOT NULL
- member_email (Field)
member_alaram (Untitled2)
- Key — Primary key — NOT NULL
- id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- alarm_apply_status (Field)
- alarm_status (Field4)
- created_datetime (Field2)
- updated_datetime (Field3)
post_file_tag (Untitled18)
- id (Key2) — Primary key — NOT NULL
- Key — Foreign key → tbl_post_file.Key — NOT NULL
- member_email (Field)
tbl_accompany
- id (Key) — Primary key — NOT NULL
- id — bigint unsigned auto_increment primary key — Foreign key → tbl_post.id — NOT NULL
- accompany_status — enum('all','part','free') default 'part'
- accompany_start_date (Field)
- accompany_end_date (Field2)
- accompany_age_range (Field3)
- id (Key2) — Foreign key → tbl_crew.id — NOT NULL
- Field4
tbl_accompany_path (Untitled)
- id — Primary key — NOT NULL
- country_name — varchar(255)
- country_city_name — varchar(255)
- country_start_date (Field)
- country_end_date (Field2)
- accompany_id — bigint unsigned auto_increment primary key — Foreign key → tbl_accompany.id — NOT NULL
- Key — Foreign key → 나라이름.Key — NOT NULL
tbl_address
- id — Primary key — NOT NULL
- address_zip_code (Field)
- address_detail (Field2)
- address (Field3)
- member_id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- created_datetime (Field4)
- updated_datetime (Field5)
tbl_banner (Untitled3)
- id (Key) — Primary key — NOT NULL
- banner_order (Field)
tbl_banner_file (Untitled4)
- id — bigint unsigned auto_increment — Foreign key → tbl_file.id — NOT NULL
- id (Key) — Foreign key → tbl_banner.id — NOT NULL
tbl_country (Untitled17)
- id (Key) — Primary key — NOT NULL
- country_name (Field)
tbl_country_diary (CopyOfUntitled17)
- id (Key) — Primary key — NOT NULL
- 시작날짜 (Field)
- 끝날짜 (Field2)
- id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- Field3
tbl_crew (CopyOfUntitled16)
- id (Key) — Primary key — NOT NULL
- crew_name (Field)
- crew_capacity (Field2)
- crew_description (Field4)
tbl_crew_file (Untitled12)
- id — bigint unsigned auto_increment — Foreign key → tbl_file.id — NOT NULL
- id (Key) — Foreign key → tbl_crew.id — NOT NULL
tbl_crew_member (Untitled16)
- id (Key) — Primary key — NOT NULL
- crew_id (Key2) — Foreign key → tbl_crew.id — NOT NULL
- member_id (id) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- crew_role (Field)
tbl_diary (Untitled9)
- id (Key) — Primary key — NOT NULL
- diary_status (Field5)
- diary_start_date (Field6)
- diary_end_date (Field7)
- diary_secret (Field10) — public, private
- id — bigint unsigned auto_increment — Foreign key → tbl_post.id — NOT NULL
tbl_diary_country_path (Untitled22)
- id (Key) — Foreign key → tbl_diary.id — NOT NULL
- id (Key2) — Foreign key → tbl_country_diary.id — NOT NULL
tbl_diary_file (Untitled10)
- Key2 — Primary key — NOT NULL
- id — bigint unsigned auto_increment — Foreign key → tbl_file.id — NOT NULL
- id (Key) — Foreign key → tbl_diary.id — NOT NULL
- left (Field)
- top (Field2)
tbl_file
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- file_origin_name — varchar(255) — NOT NULL
- file_path — varchar(255) — NOT NULL
- file_name — varchar(255) — NOT NULL
- created_datetime — datetime default current_timestamp — NOT NULL
- updated_datetime — datetime default current_timestamp — NOT NULL
tbl_inqury (Untitled5)
- id (Key) — Primary key — NOT NULL
- inqury_title (Field)
- inqury_content (Field2)
- member_id (id) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- created_datetime (Field3)
- updated_datetime (Field4)
tbl_inqury_reply (Untitled6)
- id — Primary key — NOT NULL
- inquiry_id (Key) — Foreign key → tbl_inqury.id — NOT NULL
- member_id (id2) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- inqury_reply_content (Field)
- created_datetime (Field2)
- updated_datetime (Field3)
tbl_like (like)
- Key — Primary key — NOT NULL
- post_id (id) — bigint unsigned auto_increment — Foreign key → tbl_post.id — NOT NULL
- member_id (id2) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
tbl_like_alarm (like_alarm)
- id (Key2) — Primary key — NOT NULL
- alarm_status (Field5)
- created_datetime (Field3)
- updated_datetime (Field4)
- like_id (Key) — Foreign key → tbl_like.Key — NOT NULL
tbl_member
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- member_name (mebmer_name) — varchar(255)
- member_phone — varchar(255)
- member_email — varchar(255)
- member_url — varchar(255)
- member_birth — tinyint
- member_gender — enum( 'male', 'female') default 'male'
- member_mbti — char(4)
- member_password — varchar(255)
- created_datetime — datetime default current_timestamp
- updated_datetime — datetime default current_timestamp
- member_status — enum('active','inactive') default 'active'
- member_provider (Field)
- kakao_img_url (Field2)
- member_social_email (Field3)
- member_role (Field4) — enum('member','admin','guest') default 'member'
- member_passport_number (Field5)
- 소개글 (Field6)
tbl_member_file
- id — bigint unsigned auto_increment — Foreign key → tbl_file.id — NOT NULL
- id (id2) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
tbl_notice (Untitled7)
- id (Key) — Primary key — NOT NULL
- id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- notice_title (Field)
- notice_content (Field2)
- created_datetime (Field3)
- updated_datetime (Field4)
tbl_payment
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- created_datetime — datetime default current_timestamp
- updated_datetime — datetime default current_timestamp
- member_id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- id (Key) — Foreign key → tbl_payment_status.id — NOT NULL
tbl_payment_status (Untitled11)
- id (Key) — Primary key — NOT NULL
- payment_status (Field) — enum('pending','refund','success')
- created_datetime (Field2)
- updated_datetime (Field3)
- purchase_id (Key2) — Foreign key → tbl_purchase.id — NOT NULL
tbl_payment_status_alarm (Untitled14)
- id (Key) — Primary key — NOT NULL
- alaram_status (Field)
- payment_status (Key2) — Foreign key → tbl_payment_status.id — NOT NULL
- created_datetime (Field3)
- updated_datetime (Field2)
tbl_post
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- post_title — varchar(255)
- post_read_count — smallint
- post_like_count — smallint
- post_status — enum('active','inactive') default 'active'
- created_datetime — datetime default current_timestamp
- updated_datetime — datetime default current_timestamp
tbl_post_alarm (tbl_alarm)
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- alarm_status — enum('active','inactive') default 'active'
- created_datetime — datetime default current_timestamp — NOT NULL
- updated_datetime — datetime default current_timestamp — NOT NULL
- id (id2) — Foreign key → tbl_reply.id — NOT NULL
tbl_post_file (post_file)
- Key — Primary key — NOT NULL
- id — bigint unsigned auto_increment — Foreign key → tbl_file.id — NOT NULL
- left (Field)
- top (Field2)
- id (section_id) — Foreign key → tbl_post_section.id — NOT NULL
tbl_post_section (section)
- id (Key) — Primary key — NOT NULL
- content (Field)
- member_id (id) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- id (id2) — bigint unsigned auto_increment — Foreign key → tbl_post.id — NOT NULL
tbl_purchase
- id (Key) — Primary key — NOT NULL
- id — bigint unsigned auto_increment primary key — Foreign key → tbl_post.id — NOT NULL
- purchase_product_price — int
- purchase_limit_time — datetime
- purchase_product_count — tinyint
tbl_reply (Untitled8)
- id — Primary key — NOT NULL
- reply_content (Field)
- post_id (id2) — bigint unsigned auto_increment — Foreign key → tbl_post.id — NOT NULL
- member_id (id3) — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
tbl_reports
- id — bigint unsigned auto_increment — Primary key — NOT NULL
- report_content — varchar(255) — NOT NULL
- created_datetime — datetime default current_timestamp — NOT NULL
- updated_datetime — datetime default current_timestamp — NOT NULL
- report_process_status — enum('pending','reject,'resolved') default 'pending'
- member_id — bigint unsigned auto_increment — Foreign key → tbl_member.id — NOT NULL
- post_id — bigint unsigned auto_increment — Foreign key → tbl_post.id — NOT NULL
나라이름 (Untitled20)
- Key — Primary key — NOT NULL
크루랑 다이어리 연결 (Untitled19)
- Key3 — Primary key — NOT NULL
- id (Key) — Foreign key → tbl_diary.id — NOT NULL
- id (Key2) — Foreign key → tbl_crew.id — NOT NULL