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