onFree

Tables (27)

admin_user (관리자)

  • 관리자PK (admin_user_id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(50)
  • 아이디 (email) — VARCHAR2(200)
  • 비밀번호 (password) — VARCHAR2(200)
  • 권한 (role) — VARCHAR(10)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — Date

announcement (프로젝트공고)

  • 공고PK (announcement_id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(200)
  • 내용 (content) — VARCHAR(2000)
  • 메인이미지 (main_image_url) — VARCHAR(500)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

announcement_chat_message (공고지원 채팅 메시지)

  • 공고채팅메시지PK (announcement_chat_message_id) — BIGINT — Primary key — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 보낸사람 (sender_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 읽기여부 (read_or_not) — bool
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

artist_drawing_field (작가 그림분야)

  • 작가그림분야PK (artist_drawing_field_id) — BIGINT — Primary key — NOT NULL
  • 작가PK (artist_user_id) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 그림분야PK (drawing_field_id) — BIGINT — Foreign key → drawing_field.그림분야PK — NOT NULL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

artist_user (작가)

  • 유저PK (user_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 포트폴리오개인URL (portfolio) — VARCHAR(200)

artist_user_announcement_apply (공고지원)

  • 공고지원PK (artist_use_announcement_id) — BIGINT — Primary key — NOT NULL
  • 공고PK (announcement_id2) — BIGINT — Foreign key → announcement.공고PK — NOT NULL
  • 유저PK (user_id) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — Date

artist_user_real_time_requst_apply (실시간의뢰지원)

  • 실시간 의뢰 지원 PK (artist_user_real_time_requst_apply_id) — BIGINT — Primary key — NOT NULL
  • 실시간의뢰PK (real_time_requst_id) — BIGINT — Foreign key → real_time_request.실시간의뢰PK — NOT NULL
  • 지원작가PK (artist_user_id) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

artist_user_recruitment_apply (채용지원)

  • 채용지원ID (artist_user_recruitment_apply) — BIGINT — Primary key — NOT NULL
  • 채용PK (recruitment_id) — BIGINT — Foreign key → recruitment.채용PK — NOT NULL
  • 유저PK (user_id) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 생성날짜 (create_at) — DATE
  • 수정날짜 (updated_at) — Date

chat_room (채팅방)

  • 채팅방PK (chat_room_id) — BIGINT — Primary key — NOT NULL
  • 채팅방타입 (chat_type) — CHAR(1)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

code (코드)

  • 코드PK (code_id) — Primary key — NOT NULL
  • 코드그룹PK (code_group_id) — BIGINT — Foreign key → codeGroup.코드그룹PK — NOT NULL
  • 코드명 (code_name) — BIGINT
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

codeGroup (코드그룹)

  • 코드그룹PK (code_group_id) — BIGINT — Primary key — NOT NULL
  • 그룹명 (group_name) — BIGINT
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

drawing_field (그림분야)

  • 그림분야PK (drawing_field_id) — BIGINT — Primary key — NOT NULL
  • 분야명 (field_name) — VARCHAR2(50)
  • 사용유무 (disabled) — BOOL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

filePath (파일주소)

  • Key — Primary key — NOT NULL

notice (공지게시판)

  • 공지PK (notice_id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(100)
  • 내용 (content) — VARCHAR(2000)
  • 상단등록 (top) — BOOL
  • 숨김여부 (disabled) — BOOL
  • 조회수 (view) — INT
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

payment (결제)

  • 결제PK (payment_id) — BIGINT — Primary key — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 결제상태 (patment_status) — VARCHAR(20)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — Date
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)
  • 결제금액 (amount) — BIGINT

portfolio (포트폴리오)

  • 포트폴리오PK (portfolio_id) — BIGINT — Primary key — NOT NULL
  • 유저PK (user_id) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 제목 (title) — VARCHAR(200)
  • 내용 (content) — VARCHAR(2000)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — Date
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

question (질문게시판)

  • 질문PK (question_id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(100)
  • 내용 (content) — VARCHAR(2000)
  • 숨김여부 (disabled) — BOOL
  • 조회수 (view) — INT
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

real_time_request (실시간 의뢰)

  • 실시간의뢰PK (real_time_requst_id) — BIGINT — Primary key — NOT NULL
  • 의뢰자유저PK (request_user_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 제목 (title) — VARCHAR(200)
  • 내용 (content) — VARCHAR(2000)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

real_time_request_chat_message (실시간 의뢰 채팅 메시지)

  • 실시간 의뢰채팅메시지PK (real_time_request_chat_message) — BIGINT — Primary key — NOT NULL
  • 채팅방룸 PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 보낸사람 (sender_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 읽기여부 (read_or_not) — bool
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — Date

recruitment (채용)

  • 채용PK (recruitment_id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(200)
  • 내용 (content) — VARCHAR(2000)
  • 메인이미지 (main_image_url) — VARCHAR(500)
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

recruitment_chat_message (채용지원 메시지)

  • 공고채팅메시지PK (recruitment_chat_message_id) — BIGINT — Primary key — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 보낸사람 (sender_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 읽기여부 (read_or_not) — bool
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

refund (환불)

  • 환불PK (refund_id) — BIGINT — Primary key — NOT NULL
  • 결제PK (payment_id) — BIGINT — Foreign key → payment.결제PK — NOT NULL
  • 환불상태 (refund_status) — VARCHAR(20)
  • 환불 사유 (refund_reason) — VARCHAR(500)
  • 환불금액 (amount) — BIGINT
  • 환불대상 (refund_user_name) — VARCHAR(200)
  • 생성날짜 (created_at) — DATE
  • 수정한날짜 (updated_at) — DATE

request_apply (의뢰지원)

  • 의뢰지원PK (request_apply_id) — BIGINT — Primary key — NOT NULL
  • 의뢰자PK (user_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 작가PK (artist_user) — BIGINT — Foreign key → artist_user.유저PK — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

request_chat_message (의뢰지원메시지)

  • 의뢰PK (request_chat_message_id) — BIGINT — Primary key — NOT NULL
  • 채팅방PK (chat_room_id) — BIGINT — Foreign key → chat_room.채팅방PK — NOT NULL
  • 보낸사람 (sender_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 읽기여부 (read_or_not) — bool
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE

user (모든유저)

  • 유저PK (user_id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(50)
  • 이메일 (email) — VARCHAR2(100)
  • 비밀번호 (password) — VARCHAR2(200)
  • 전화번호 (phone_number) — CHAR(13)
  • 은행명 (bank_name) — VARCHAR(20)
  • 계좌번호 (account-number) — VARCHAR2(20)
  • 서비스 동의 (service_agree) — bool
  • 운영정책동의 (policy_agree) — bool
  • 개인정보동의 (personal_info_agree) — bool
  • 광고동의 (advertisement_agree) — bool
  • 19세인증 (adult_certification) — bool
  • 성별 (gender) — VARCHAR2(6) — NOT NULL
  • 프로필사진 (profile_image) — VARCHAR(100)
  • 권한 (role) — VARCHAR(10)
  • 생성날짜 (crated_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 제제 (rock) — bool

user_black (유저 블랙)

  • 유저블랙PK (user_black) — BIGINHT — Primary key — NOT NULL
  • 유저PK (user_id) — BIGINT — Foreign key → user.유저PK — NOT NULL
  • 제제사유 (sanction_reason) — VARCHAR(200)
  • 제재만료시기 (expiration_date) — DATE
  • 제재취소 (disabled) — BOOL
  • 생성날짜 (created_at) — DATE
  • 수정날짜 (updated_at) — DATE
  • 만든사람 (created_user) — VARCHAR(50)
  • 수정한사람 (updated_user) — VARCHAR(50)

user_history (유저히스토리)

  • 유저히스토리PK (user_history_id) — BIGINT — Primary key — NOT NULL
  • 유저PK (user_id) — BIGINT
  • 이름 (name) — VARCHAR2(50)
  • 이메일 (email) — VARCHAR2(100)
  • 비밀번호 (password) — VARCHAR2(200)
  • 전화번호 (phone_number) — CHAR(13)
  • 은행명 (bank_name) — VARCHAR(20)
  • 계좌번호 (account-number) — VARCHAR2(20)
  • 서비스 동의 (service_agree) — bool
  • 운영정책동의 (policy_agree) — bool
  • 개인정보동의 (personal_info_agree) — bool
  • 광고동의 (advertisement_agree) — bool
  • 19세인증 (adult_certification) — bool
  • 성별 (gender) — VARCHAR2(6) — NOT NULL
  • 프로필사진 (profile_image) — VARCHAR(100)
  • 권한 (role) — VARCHAR(10)
  • 포트폴리오 개인 URL (portfolio_url) — VARCHAR(200)
  • 생성날짜 (crated_at) — DATE
  • 수정날짜 (updated_at) — DATE