ㅁㄴㅇㄹ
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)