Reviewfolio
Tables (6)
Comment (댓글)
- id (Key) — Number — Primary key — NOT NULL
- id (Key2) — Number — Foreign key → RequestPost.id — NOT NULL
- id — Number — Foreign key → RequestPost.id — NOT NULL
- content (Field) — Text — NOT NULL
Payment (결제)
- id (Key) — Number — Primary key — NOT NULL
- quantity (Field) — Number — NOT NULL
Programmer (개발자)
- id (Key) — Number — Primary key — NOT NULL
- id (Key2) — Number — Foreign key → RequestPost.id — NOT NULL
- id (id2) — Number — Foreign key → RequestPost.id — NOT NULL
- carrer_year (Field) — Number
- refund_point (Field2) — Number
- point (Field3) — Number
- request_list (Field4) — Array
- id — Number — Foreign key → User.id — NOT NULL
RequestPost (리뷰 요청 글)
- id (Key) — Number — Primary key — NOT NULL
- id — Number — Foreign key → User.id — NOT NULL
- title (Field) — String — NOT NULL
- max_reviewer (Field2) — Number
- file_url (Field3) — Text — NOT NULL
- body (Field4) — Text — NOT NULL
- status (Field5) — Boolean
TicketHistory (티켓 기록)
- id (Key) — Number — Primary key — NOT NULL
- status (Boolean) — NOT NULL
User (사용자)
- id — Number — Primary key — NOT NULL
- name (Field) — String — NOT NULL
- is_programmer (Field2) — Boolean — NOT NULL
- info_check (Field3) — Boolean — NOT NULL
- ticket (Field5) — Number