Team Project-1
Tables (4)
ATTACH_FILE_T
- file_seq — integer — Primary key — NOT NULL — 첨부파일
- board_seq — integer — Foreign key → BOARD_T.board_seq — NOT NULL — 글번호
- ori_file_nm — varchar(200) — NOT NULL — 원본
- ori_file_ext_nm — varchar(10) — 원본
- upd_file_path — varchar(500) — NOT NULL — 업로드
- upd_file_nm — varchar(200) — NOT NULL — 업로드
- file_desc — varchar(200) — 파일
- use_yn — char(1) — NOT NULL
- reg_user_id — varchar(50) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- upd_user_id — varchar(50) — NOT NULL
- upd_dttm — timestamp — NOT NULL
BOARD_T
- board_seq — integer — Primary key — NOT NULL
- code_id — varchar(10) — NOT NULL — 분류코드
- board_title — varchar(100) — NOT NULL — 게시물
- board_content — text — 게시물
- use_yn — char(1) — NOT NULL
- reg_user_id — varchar(50) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- upd_user_id — varchar(50) — NOT NULL
- upd_dttm — timestamp — NOT NULL
CODE_T
- code_id — varchar(10) — Primary key — NOT NULL
- code_name — varchar(100) — NOT NULL — 코드
- up_code_id — varchar(10) — 상위
- ord_no — integer — NOT NULL — 정렬
- use_yn — char(1) — NOT NULL
- reg_user_id — varchar(50) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- upd_user_id — varchar(50) — NOT NULL
- upd_dttm — timestamp — NOT NULL
USER_T
- user_id — varchar(50) — Primary key — NOT NULL
- user_password — varchar(50) — NOT NULL — 사용자
- user_name — varchar(50) — NOT NULL — 사용자
- use_yn — char(1) — NOT NULL — 사용여부
- reg_user_id — varchar(50) — NOT NULL — 등록자
- reg_dttm — timestamp — NOT NULL — 등록일시
- upd_user_id — varchar(50) — NOT NULL — 수정자
- upd_dttm — timestamp — NOT NULL — 수정일시