Shopping
Tables (8)
TB_BOARD (자유게시판)
- board_idx (게시글번호) — bigint — Primary key — NOT NULL
- title (제목) — varchar(256)
- content (내용) — text
- reg_dt (작성일자) — varchar(16)
- mod_dt (수정일자) — varchar(16)
- board_type (글분류) — varchar(1)
- reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL
TB_BOARD_FILE (자유게시판첨부파일)
- board_file_idx (첨부파일번호) — bigint — Primary key — NOT NULL
- file_name (파일명) — varchar(128)
- file_path (저장경로) — varchar(256)
- reg_idx (작성자) — bigint
- reg_dt (작성일자) — varchar(16)
- board_idx (게시글번호) — bigint — Foreign key → TB_BOARD.board_idx — NOT NULL
TB_COMMENT (자유게시판댓글)
- comment_idx (댓글번호) — bigint — Primary key — NOT NULL
- content (내용) — text
- reg_dt (작성일자) — varchar(16)
- mod_dt (수정일자) — varchar(16)
- board_idx (게시글번호) — bigint — Foreign key → TB_BOARD.board_idx — NOT NULL
- reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL
TB_REG_ITEMS (판매물건)
- reg_item_idx (판매등록물건번호) — bigint — Primary key — NOT NULL
- item_name (물건명) — varchar(16)
- item_count (수량) — int
- item_price (판매가) — int
- item_info (판매정보) — text
- item_type (물건분류) — int
- reg_dt (작성일자) — varchar(16)
- reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL
- avg_score (평균평점) — float
TB_REG_ITEM_ANSWER (답변)
- reg_item_ans_idx (답변번호) — bigint — Primary key — NOT NULL
- title (제목) — varchar(256)
- content (내용) — text
- reg_idx (작성자) — bigint
- reg_dt (작성일자) — varchar(16)
- reg_item_ques_idx (질문번호) — bigint — Foreign key → TB_REG_ITEM_QUESTION.reg_item_ques_idx — NOT NULL
TB_REG_ITEM_QUESTION (질문)
- reg_item_ques_idx (질문번호) — bigint — Primary key — NOT NULL
- title (제목) — varchar(256)
- content (내용) — text
- reg_idx (작성자) — bigint
- reg_dt (작성일자) — varchar(16)
- reg_item_idx (판매등록물건번호) — bigint — Foreign key → TB_REG_ITEMS.reg_item_idx — NOT NULL
TB_REG_ITMES_BUY_NOTE (구매후기)
- reg_buy_note_idx (구매후기번호) — bigint — Primary key — NOT NULL
- reg_idx (작성자) — bigint
- reg_dt (작성일자) — varchar(16)
- mod_dt (수정일자) — varchar(16)
- title (제목) — varchar(256)
- content (내용) — text
- score (평점) — float
- reg_item_idx (판매등록물건번호) — bigint — Foreign key → TB_REG_ITEMS.reg_item_idx — NOT NULL
TB_USER (회원)
- user_idx (회원번호) — bigint — Primary key — NOT NULL
- user_id (아이디(이메일)) — varchar(16)
- password (비밀번호) — varchar(128)
- name (이름) — varchar(16)
- phone (전화번호) — varchar(16)
- email_yn (이메일수신동의여부) — varchar(1)
- si_do (주소1(시도)) — varchar(16)
- si_gun_gu (주소2(시군구)) — varchar(16)
- eup_myeon_dong (주소3(읍면동)) — varchar(16)
- addr_detail (주소4(상세주소)) — varchar(32)
- authority (권한) — varchar(16)