practice

Tables (21)

Budget (예산)

  • budget_id (Key5) — INT — Primary key — NOT NULL
  • council_id (Key6) — INT — Foreign key → council.council_id — NOT NULL
  • user_id (Key22) — VARCHAR — Foreign key → council.user_id — NOT NULL
  • budget_month (예산안 월) — INT
  • budget_year (예산안 년도) — INT
  • budget_name (예산안 이름) — VARCHAR

Budget_Info (예산안 상세)

  • budget_info_id (Key) — INT — Primary key — NOT NULL
  • budget_id (Key2) — INT — Foreign key → Budget.budget_id — NOT NULL
  • council_id (Key6) — INT — Foreign key → Budget.council_id — NOT NULL
  • user_id (Key22) — VARCHAR — Foreign key → Budget.user_id — NOT NULL
  • budget_goal (사용목적) — TEXT
  • budget_day (일자) — DATETIME
  • budget_user_name (담당자) — VARCHAR
  • budget_amount (예상사용액) — INT

Settlement (결산)

  • settlement_id (Key5) — INT — Primary key — NOT NULL
  • account_id (Key3) — INT — Foreign key → account.account_id — NOT NULL
  • council_id (Key) — INT — Foreign key → account.council_id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → account.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → account.school_id — NOT NULL
  • settlement_year (결산안 년도) — INT
  • settlement_month (결산안 월) — INT
  • settlement_name (결산안 이름) — VARCHAR

Settlement_Info (결산안 상세)

  • settlement_info_id (Key) — INT — Primary key — NOT NULL
  • settlement_id (Key5) — INT — Foreign key → Settlement.settlement_id — NOT NULL
  • settlement_name (거래내역 이름) — VARCHAR
  • Field (입금 대상) — VARCHAR
  • Field (출금 대상) — VARCHAR
  • Field (거래금액) — INT
  • Field (거래 전 잔액) — INT
  • Field (거래 후 잔액) — INT
  • Field (거래일자) — DATETIME
  • Field (입금/출금) — ENUM
  • Field (거래 카테고리) — ENUM

account (계좌)

  • account_id (Key3) — INT — Primary key — NOT NULL
  • council_id (Key) — INT — Foreign key → council.council_id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → council.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → council.school_id — NOT NULL
  • account_num (Field) — INT
  • account_price (Field2) — INT

board (Untitled)

  • board_id (Key3) — INT — Primary key — NOT NULL
  • council_id (Key) — INT — Foreign key → council.council_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → council.school_id — NOT NULL
  • board_cate_id (Key5) — INT — Foreign key → board_category.board_cate_id — NOT NULL
  • board_name (Field4) — VARCHAR

board_category (게시판 카테고리)

  • board_cate_id (Key) — INT — Primary key — NOT NULL
  • board_cate_name (Field) — VARCHAR

board_post (게시판 내 글쓰기)

  • post_id (Key6) — INT — Primary key — NOT NULL
  • board_id (Key3) — INT — Foreign key → board.board_id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • post_title (Field2) — VARCHAR
  • post_content (Field) — TEXT
  • post_create_date (Field3) — DATETIME
  • post_modify_date (Field4) — DATETIME

borrow (대여)

  • borrow_id (Key) — INT — Primary key — NOT NULL
  • council_id (Key2) — INT — Foreign key → council.council_id — NOT NULL
  • user_id (Key22) — VARCHAR — Foreign key → council.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → council.school_id — NOT NULL
  • borrow_name (물품 이름) — VARCHAR
  • borrow_account (물품 수량) — INT
  • borrow_image (물품 이미지) — VARCHAR

borrow_category (대여물품 카테고리)

  • cate_id (Key) — INT — Primary key — NOT NULL
  • borrow_id (Key2) — INT — Foreign key → borrow.borrow_id — NOT NULL
  • user_id (Key222) — VARCHAR — Foreign key → borrow.user_id — NOT NULL
  • cate_name (Field) — VARCHAR

borrow_request (대여 요청)

  • borrow_request_id (Key3) — INT — Primary key — NOT NULL
  • user_id (Key) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • borrow_id (Key2) — INT — Foreign key → borrow.borrow_id — NOT NULL
  • council_id (Key22) — INT — Foreign key → borrow.council_id — NOT NULL
  • request_date (예약일자) — DATETIME
  • modifiy_date (수정일자) — DATETIME
  • cancle_yn (요청상태) — INT/ENUM

council (학생회/자치회)

  • council_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → school.school_id — NOT NULL
  • user_name (학생 이름) — VARCHAR
  • council_name (자치회 이름) — VARCHAR
  • council_manager_yn (자치회 관리자 여부) — INT/ENUM

count_auth (계좌 인증 여부)

  • auth_id (Key) — INT — Primary key
  • user_id (Key2) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • Field2
  • Field3

post_comment (글의 댓글)

  • comment_id (Key2) — INT — Primary key — NOT NULL
  • post_id (Key6) — INT — Foreign key → board_post.post_id — NOT NULL
  • user_id (Key) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • parent_id (대댓글) — INT — Foreign key → post_comment.comment_id — NOT NULL
  • comment_content (댓글 내용) — TEXT
  • comment_delete_yn (댓글 삭제 여부) — INT/ENUM
  • comment_create_date (댓글 작성 시간) — DATETIME
  • comment_modify_date (댓글 수정 시간) — DATETIME

request_result (대여요청 결과)

  • request_result_id (Key) — INT — Primary key — NOT NULL
  • borrow_request_id (Key3) — INT — Foreign key → borrow_request.borrow_request_id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → borrow_request.user_id — NOT NULL
  • borrow_id (Key22) — INT — Foreign key → borrow_request.borrow_id — NOT NULL
  • council_id (Key222) — INT — Foreign key → borrow_request.council_id — NOT NULL
  • request_result (예약 결과) — ENUM/INT
  • request_reason (반려시 반려 사유) — VARCHAR

scheduler (일정)

  • schedule_id (Key) — INT — Primary key — NOT NULL
  • council_id (Key2) — INT — Foreign key → council.council_id — NOT NULL
  • user_id (Key22) — VARCHAR — Foreign key → council.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → council.school_id — NOT NULL
  • schedule_content (Field) — TEXT
  • url (Field2) — VARCHAR
  • schedule_name (Field3) — VARCHAR
  • schedule_date (Field4) — DATETIME

school (학교)

  • school_id (Key) — INT — Primary key — NOT NULL
  • school_name (학교 이름) — VARCHAR — NOT NULL
  • school_email (학교 이메일) — VARCHAR
  • school_email2 (학교 이메일2) — VARCHAR
  • school_url (학교 url) — VARCHAR
  • school_icon (학교 로고) — VARCHAR

subscription (회비 납부 요청)

  • subscription_id (Key3) — INT — Primary key — NOT NULL
  • council_id (Key) — INT — Foreign key → council.council_id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → council.user_id — NOT NULL
  • school_id (Key4) — INT — Foreign key → council.school_id — NOT NULL
  • subscription_name (회비 납부요청 제목) — VARCHAR
  • subscription_amount (회비 납부 금액) — INT

user (유저)

  • user_id (Key) — VARCHAR — Primary key — NOT NULL
  • user_pw (Field4) — VARCHAR
  • user_name (Field2) — VARCHAR
  • user_nick (Field3) — VARCHAR
  • user_create_date (Field5) — DATETIME
  • user_modify_date (Field6) — DATETIME
  • user_school_auth_yn (Field7) — ENUM
  • user_count_auth_yn (Field) — ENUM

user_profile (유저 프로필)

  • user_profile_id (Key2) — Primary key — NOT NULL
  • user_id (Key) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • url (Field) — VARCHAR
  • user_create_date (Field2) — DATETIME
  • user_modifiy_date (Field3) — DATETIME

user_school (유저 학교 인증)

  • user_id (Key) — VARCHAR — Foreign key → user.user_id — NOT NULL
  • school_id (Key2) — INT — Foreign key → school.school_id — NOT NULL
  • user_school_email (유저 학교 이메일)