네이버 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