User Upload function

테이블 (4)

FILE META DATA (Untitled2)

  • (FILE_METAdATA) — PK — 기본 키 — NOT NULL
  • (POST_ID) — FK — 외래 키 → Post.POST_ID — NOT NULL
  • (USER_ID) — FK — 외래 키 → Post.USER_ID — NOT NULL
  • (ORIGINAL_NAME) — unique, not null
  • (STORED_NAME) — unique, not null
  • (FILE_PATH)
  • (FILE_SIZE) — NOT NULL
  • (MIME_TYPE) — NOT NULL
  • (UPLOADED_AT) — NOT NULL
  • (DELETED_AT) — NOT NULL
  • (IS_DRAFTED) — not null
  • (CREATED_AT) — NOT NULL
  • (IS_DELETED) — 게시글 저장

POST 게시글 임시저장 (Untitled4)

  • POST_SAVED_ID (Key) — autoincrement(pk) — 기본 키 — NOT NULL
  • POST_id (BIGINT) — autoincrement(fk) — 외래 키 → Post.POST_ID — NOT NULL
  • USER_ID (bigint) — autoincrement(fk) — 외래 키 → Post.USER_ID — NOT NULL
  • USER_ID (Field) — bigint
  • POST_ID (Field2) — bigint
  • CREATE_AT (Field3) — datetime

Post (Untitled)

  • (POST_ID) — PK — 기본 키 — NOT NULL
  • (USER_ID) — FK — 외래 키 → USER.USER_ID — NOT NULL
  • (IS_DRAFTED) — NOT NULL
  • (NAME) — unique, not null
  • (CREATED_AT) — NOT NULL
  • (NAME_) — unique, not null
  • (DELETED_AT) — NOT NULL
  • (CONTENT) — null
  • (TITLE) — not null
  • (IS_DELETED) — DEFAULT 0

USER (partner_id)

  • USER_ID (bigint) — autoincrement(pk) — 기본 키 — NOT NULL
  • (EMAIL) — unique, not null
  • (PASSWORD) — unique, not null
  • (UPDATED_AT) — NOT NULL
  • (CREATED_AT) — NOT NULL
  • (NICKNAME) — NOT NULL
  • (EXPIRE_AT) — null
  • (NAME) — not null
  • (IS_DELETED) — NOT NULL
  • (DELETED_AT) — NOT NULL