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