settle

Tables (8)

t_creator_settle (Untitled6)

  • no (Key) — Primary key — NOT NULL
  • type (Field)

t_event (Untitled2)

  • no (Key) — int — Primary key — NOT NULL

t_event_membership_settle (Untitled5)

  • no (Key) — Primary key — NOT NULL
  • total_settle_amount (Field2)
  • accumulated_settle_amount (Field3)
  • date (Field4)
  • complete_date (Field5)
  • total_round (Field6)
  • status (Field7)
  • ins_datetime (Field8)
  • del_datetime (Field9)
  • event_no (Field)

t_event_settle_mapping (Untitled7)

  • no (Key) — Primary key — NOT NULL
  • settle_no (Key2) — Foreign key → t_creator_settle.no — NOT NULL
  • event_settle_no (Key3) — Foreign key → t_event_membership_settle.no — NOT NULL
  • settle_round (Field)

t_event_settle_payment_mapping (CopyOfUntitled)

  • no (Key) — Foreign key → t_payment.no — NOT NULL
  • event_settle_no (Key2) — Foreign key → t_event_membership_settle.no — NOT NULL
  • payment_no (Field3) — int
  • currency_no (Field4) — int
  • remain_price (Field5) — decimal(10,2)

t_event_ticket (Untitled3)

  • no (Key) — int — Foreign key → t_event.no — NOT NULL

t_event_ticket (Untitled4)

  • no (Key) — int — Foreign key → t_event_ticket.no — NOT NULL
  • month_period (Field) — int

t_payment (Untitled)

  • no (Key) — Primary key — NOT NULL