네이버 MYBOX
테이블 (3)
Directory (directory)
- Directory Id (directory_id) — BIGINT(11) — 기본 키 — NOT NULL
- Owner Id (owner_id) — BIGINT(11) — 외래 키 → User.User Id — NOT NULL
- Directory Name (directory_name) — VARCHAR(100) — NOT NULL
- Directory SIze (directory_size) — BIGINT(11) — NOT NULL
- Created Date (created_dt) — DATETIME — NOT NULL
- Modified Date (modified_dt) — DATETIME — NOT NULL
- Parent Directory (parent_directory) — BIGINT(11) — 외래 키 → Directory.Directory Id — NOT NULL
File (file)
- File Id (file_id) — BIGINT(11) — 기본 키 — NOT NULL
- Owner Id (owner_id) — BIGINT(11) — 외래 키 → User.User Id — NOT NULL
- File Name (file_name) — VARCHAR(100) — NOT NULL
- File Size (file_size) — BIGINT(11) — NOT NULL
- Created Date (created_dt) — DATETIME — NOT NULL
- Modified Date (modified_dt) — DATETIME — NOT NULL
- Parent Directory (parent_directory) — BIGINT(11) — 외래 키 → Directory.Directory Id — NOT NULL
User (USER)
- User Id (user_id) — BIGINT(11) — 기본 키 — NOT NULL
- User Name (user_name) — VARCHAR(20) — NOT NULL
- User Password (user_password) — VARCHAR(255) — NOT NULL
- Max Usage (max_usage) — BIGINT(11) — NOT NULL
- Current Usage (current_usage) — BIGINT(11) — NOT NULL
- Created Date (created_dt) — DATETIME — NOT NULL
- Modified Date (modified_dt) — DATETIME — NOT NULL