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