fileEncoding
Tables (4)
item
- item_id — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — NOT NULL
- 원본이름 (original_name) — varchar(255) — NOT NULL — 원본 이름
- 원본경로 (original_path) — varchar(255) — NOT NULL — 원본 경로
- 원본확장자 (original_extend_type) — varchar(255) — 원본파일확장자
- 저장이름 (save_name) — varchar(255) — NOT NULL — 저장된 파일이름
- 저장경로 (save_path) — varchar(255) — NOT NULL — 저장파일 경로
- 저장확장자 (save_extend_type) — vatchar(255) — 저장된파일 확장자
- 상태 (status) — varchar(255) — NOT NULL — 활성화, 해지
- 생성날짜 (created_at) — datetime — NOT NULL
- 수정날짜 (modified_at) — datetime — NOT NULL
member
- member_id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- employee_id — varchar(255)
- password — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- 수정날짜 (modified_at) — datetime — NOT NULL
- 생성날짜 (created_at) — datetime — NOT NULL
upload_Items (upload_items)
- upload_items_id — bigint(20) — Primary key — NOT NULL
- item_id — bigint(20) — Foreign key → item.item_id — NOT NULL
- 업로드주문id (upload_order_id) — bigint(20) — Foreign key → upload_order.업로드주문id — NOT NULL
- member_id — bigint(20) — NOT NULL
- 생성날짜 (created_at) — datetime — NOT NULL
- 수정날짜 (modified_at) — datetime — NOT NULL
upload_order
- 업로드주문id (upload_order_id) — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
- 업로드상태 (upload_status) — varchar(255) — NOT NULL — 성공, 실패, 삭제
- 생성날짜 (created_at) — datetime — NOT NULL
- 수정날짜 (modified_at) — datetime — NOT NULL