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