REMAC

Tables (4)

CustomUser

  • PK (id) — int — Primary key — NOT NULL
  • 아이디 (username) — varchar — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 닉네임(채널명) (nickname) — varchar — NOT NULL
  • 프로필사진 (profile_image) — varchar — NOT NULL
  • 크리에이터 여부 (is_creator) — boolean — NOT NULL
  • (크리에이터)채널url (channel_url) — varchar — NOT NULL
  • (크리에이터)채널유형 (channel_category) — varchar — NOT NULL — choice
  • (크리에이터)한줄소개 (channel_intro) — varchar — NOT NULL
  • (크리에이터)은행 (bank) — varchar — NOT NULL — choice
  • (크리에이터)입금자명 (depositor) — varchar — NOT NULL
  • (크리에이터)계좌번호 (account) — varchar — NOT NULL

Product

  • PK (id) — int — Primary key — NOT NULL
  • FK (request_id) — int — Foreign key → Request.PK — NOT NULL
  • 결과물 url (product_url) — varchar — NOT NULL

Request

  • PK (id) — int — Primary key — NOT NULL
  • 리퀘스트 제목 (request_title) — varchar — NOT NULL
  • 리퀘스트 내용 (request_content) — varchar — NOT NULL
  • 리워드 (request_reward) — int — NOT NULL
  • 상태 (request_status) — varchar — NOT NULL — choice
  • 기한 (request_duedate) — datetime — NOT NULL
  • (크리에이터)요청수락 (creator_YN) — boolean — NOT NULL
  • (환불) 은행 (refund_bank) — varchar — NOT NULL — choice
  • (환불) 입금자명 (refund_depositor) — varchar — NOT NULL
  • (환불) 계좌번호 (refund_account) — varchar — NOT NULL

request_users

  • FK (user_id) — int — Foreign key → CustomUser.PK — NOT NULL
  • FK (request_id) — int — Foreign key → Request.PK — NOT NULL