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 (유저 학교 이메일)