aptManager

Tables (8)

BoardComment

  • 댓글아이디 (comm_id) — INT — Primary key — NOT NULL
  • 게시글아이디 (post_id) — INT — Foreign key → BoardPost.게시글아이디 — NOT NULL
  • 댓글작성자 (comm_w_id) — INT — Foreign key → BoardPost.게시글작성자 — NOT NULL
  • 내용 (comm_content) — VARCHAR(255) — NOT NULL
  • 작성일시 (created_datetime) — DATETIME
  • 수정일시 (modified_datetime) — DATETIME

BoardPost

  • 게시글아이디 (post_id) — INT — Primary key — NOT NULL
  • 게시글작성자 (post_w_id) — INT — Foreign key → User.회원아이디 — NOT NULL
  • 제목 (post_title) — VARCHAR(50) — NOT NULL
  • 내용 (post_content) — VARCHAR(255) — NOT NULL
  • 작성일시 (created_datetime) — DATETIME
  • 수정일시 (modified_datetime) — DATETIME

Car

  • 차량아이디 (car_id) — INT — Primary key — NOT NULL
  • 회원아이디 (car_r_id) — INT — Foreign key → User.회원아이디 — NOT NULL
  • 차량번호 (car_number) — VARCHAR(50) — NOT NULL
  • 손님여부 (guest_car) — INT — NOT NULL
  • 전기차여부 (electric_car) — INT — NOT NULL
  • 장애인여부 (disabled_car) — INT — NOT NULL
  • 등록여부 (registered) — INT — NOT NULL
  • 등록일시 (registration_datetime) — DATETIME
  • 신청일시 (application_datetime) — DATETIME

Notice

  • 공지사항아이디 (notice_id) — INT — Primary key — NOT NULL
  • 회원아이디 (noti_w_id) — INT — Foreign key → User.회원아이디 — NOT NULL
  • 제목 (title) — VARCHAR(50) — NOT NULL
  • 내용 (content) — VARCHAR(255) — NOT NULL
  • 요약 (summary) — VARCHAR(255)
  • 작성일시 (noti_w_date) — DATETIME
  • 카테고리 (noti_category) — INT — NOT NULL

User

  • 회원아이디 (id) — INT — Primary key — NOT NULL
  • 동 (dong) — VARCHAR(4) — NOT NULL
  • 호 (ho) — VARCHAR(4) — NOT NULL
  • 세대주명 (username) — VARCHAR(15) — NOT NULL
  • 비밀번호 (pw) — VARCHAR(100) — NOT NULL
  • 전화번호 (phone1) — VARCHAR(11) — NOT NULL
  • 예비 전화번호 (phone2) — VARCHAR(11)
  • 전입일 (movein) — DATE — NOT NULL
  • 권한 (isAdmin) — INT
  • 가입일시 (joinDate) — DATETIME

VoteA

  • 투표아이디 (vote_a_id) — INT — Primary key — NOT NULL
  • 투표아이디 (vote_q_id) — INT — Foreign key → VoteQ.투표아이디 — NOT NULL
  • 회원아이디 (vote_p_id) — INT — Foreign key → VoteQ.회원아이디 — NOT NULL
  • 선택항목 (selected_opt) — INT — NOT NULL
  • 참여일시 (vote_p_datetime) — DATETIME

VoteQ

  • 투표아이디 (vote_q_id) — INT — Primary key — NOT NULL
  • 회원아이디 (vote_r_id) — INT — Foreign key → User.회원아이디 — NOT NULL
  • 투표제목 (vote_title) — VARCHAR(50) — NOT NULL
  • 투표내용 (vote_content) — VARCHAR(255) — NOT NULL
  • 투표시작 (vote_s_datetime) — DATETIME
  • 투표종료 (vote_e_datetime) — DATETIME

WorkLog

  • 업무일지아이디 (w_l_id) — INT — Primary key — NOT NULL
  • 작성자 (w_w_id) — INT — Foreign key → User.회원아이디 — NOT NULL
  • 업무내용 (w_content) — VARCHAR(255) — NOT NULL
  • 업무시작 (w_start) — DATE — NOT NULL
  • 업무종료 (w_end) — DATE — NOT NULL
  • 작성일시 (w_w_datetime) — DATETIME