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