ㅁㄴㅇㄹ

Tables (12)

Auth

  • auth_idx — int — Primary key — NOT NULL
  • auth_name — varchar(50) — NOT NULL

Content

  • content_idx — int — Primary key — NOT NULL
  • content_title — varchar(50)
  • content_create — datetime
  • content_start — datetime
  • content_end — datetime
  • content_text — text
  • member_idx — int — Foreign key → Member.member_idx — NOT NULL — auto
  • auth_idx — int — Foreign key → Member.auth_idx — NOT NULL
  • content_category_idx — int — Foreign key → Content_category.content_category_idx — NOT NULL
  • did_idx — int — Foreign key → DID.did_idx — NOT NULL
  • hall_idx — int — Foreign key → DID.hall_idx — NOT NULL

Content_category

  • content_category_idx — int — Primary key — NOT NULL
  • content_category_name — varchar(50) — NOT NULL

Content_image

  • content_image_idx — int — Primary key — NOT NULL
  • content_idx — int — Foreign key → Content.content_idx — NOT NULL
  • content_image_url — varchar(255)

DID

  • did_idx — int — Primary key — NOT NULL
  • hall_idx — int — Foreign key → Villagehall.hall_idx — NOT NULL
  • did_ip — varchar(50)
  • did_on_time — datetime
  • did_off_time — datetime
  • did_pincode — varchar(50)
  • did_uptime — datetime

DID_transition

  • transition_idx — int — Primary key — NOT NULL
  • transition_on — int
  • transition_off — int
  • transition_day — datetime

Log

  • log_idx — int — Primary key — NOT NULL
  • log_content — text — NOT NULL
  • log_time — datetime — NOT NULL
  • log_category_idx — int — Foreign key → Log_category.log_category_idx — NOT NULL

Log_category

  • log_category_idx — int — Primary key — NOT NULL
  • log_category_name — varhar(50)

Member

  • member_idx — int — Primary key — NOT NULL — auto
  • auth_idx — int — Foreign key → Auth.auth_idx — NOT NULL
  • member_id — varchar(50) — NOT NULL
  • member_pw — varchar(50) — NOT NULL
  • member_phone — varchar(50)
  • member_info — varchar(200)
  • member_login — datetime

Tour_dest

  • dest_idx — int — Primary key — NOT NULL
  • dest_name — varchar(50)
  • dest_text — text

Tour_dest_image

  • dest_image_idx — int — Primary key — NOT NULL
  • dest_idx — int — Foreign key → Tour_dest.dest_idx — NOT NULL
  • dest_image_url — varchar(255)

Villagehall

  • hall_idx — int — Primary key — NOT NULL
  • hall_name — varchar(50)
  • hall_myun — varchar(50)
  • hall_dong — varchar(50)
  • hall_ri — varchar(50)
  • hall_gil — varchar(50)
  • hall_gil_address — varchar(50)
  • hall_manager — varchar(50)
  • hall_phone — varchar(50)