1
Tables (7)
Recruitment (인재 채용)
- r_seq (Key2) — INT — Primary key — NOT NULL
- r_ category (Field) — VARCHAR
- r_categoryname (Field2) — VARCHAR
- r_workplace (Field3) — VARCHAR
- r_ period (Field4) — VARCHAR
board (미래뉴스,공지사항,자료실,상담실)
- b_seq (Key) — INT — Primary key — NOT NULL
- b_id (Key3) — VARCHAR — Foreign key → user.u_id — NOT NULL
- b_title (Field) — VARCHAR
- b_contents (Field2) — VARHCAR
- b_date (Field3) — DATE
- b_hit (Field4) — INT
- b_down (Field5) — VARCHAR
- b_source (Field7) — VARCHAR
- b_number (Field8) — INT
- b_img (Field6) — VARCHAR
comment (댓글)
- c_seq (Key) — INT — Foreign key → board.b_seq — NOT NULL
- c_id (Key3) — VARCHAR — Foreign key → board.b_id — NOT NULL
- c_date (Field) — DATE
- c_time (Field2) — DATETIME
- c_contents (Field3) — VARCHAR
equipment (장비 보유 현황)
- e_seq (Key) — INT — Primary key — NOT NULL
- e_name (Field) — VARCHAR
- e_standard (Field2) — VARCHAR
- e_quantity (Field3) — VARCHAR
- e_img (Field4) — VARCHAR
m_status_by_type (유형별 관리현황)
- ms_seq (Key) — VARCHAR — Primary key — NOT NULL
- ms_visivion (Field) — VARCHAR
- ms_BusinessTargetNumber (Field2) — INT
- ms_households (Field3) — INT
- ms_area (Field4) — INT
management (관리 실적)
- m_seq (Key) — INT — Primary key — NOT NULL
- m_division (Field) — INT
- m_name (Field2) — VARCHAR
- m_topfloor (Field3) — INT
- m_constructor (Field4) — VARCHAR
- m_area (Field5) — INT
- m_img (Field6) — VARCHAR
user (회원 정보)
- u_id (Key) — VARCHAR — Primary key — NOT NULL
- u_pw (Field) — VARCHAR
- u_phonenumber (Field2) — VARCHAR
- u_email (Field3) — VARCHAR