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